HELP! -Runtime error issue -Trying to automate Excel import to Access

[BrownRecluse]

Nevermind, I'm trying a new approach...

 

[boblarson]

Your syntax is all wrong -

DoCmd.TransferSpreadsheet , , "tempTable" & sheetName, fname, True, sheetName

You aren't putting the inputs in the right spot. You aren't telling it whether it is an import or export, what Excel version, nowhere do you have assigned the value for sheetName, you don't need the range for the full sheet. The correct syntax is:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TableName", "FileName", True

 

[BrownRecluse]

Is there any way besides using TransferSpreadsheet to do automatic imports?

Thanks again for you help,

-Susan

 

[RoyVidar]

Check out http://support.microsoft.com/kb/278973 or http://support.microsoft.com/kb/295646/EN-US/