i have a workbook(xls) that has 3 sheets (a,b,c)<BR>i have an mdb that has 3 tables (a,b,c)<BR> i am trying to point a macro to the workbook to take and import sheet a to table a sheet b to table b and sheet c to table c in Access 97<BR><BR>When i use the action TransferSpreadsheet<BR>with a transfer type of import<BR>and a file name \serverdrive_dstuffwkbk.xlsa<BR><BR>it gives me a nasty message.<BR><BR>is there some way of doing this?<BR><BR>thanks in advance<BR>