Why won't my code for importing an Excel file work??

[paychexanalyst]

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblSalesProspects", "\\corpnt02\ens_sh\Financial Risk Management\Risk Analysis\Equifax Automation Project\DSRLDS.xls", True, ""


I've tried using different versions of Excel (i.e. acSpreadsheetTypeExcel8). Nothing seems to be working. The excel file has Field Names already, it seems like this should be straight forward. If someone could let me know I would reall appreciate it!!

Thanks in advance.

 

[boblarson]

First thing is to remove the

, ""

at the end. If you aren't supplying a range, don't even put it there. You don't supply an argument for that if you don't have one to supply.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[scottian]

This works for me

DoCmd.TransferSpreadsheet acImport, 8, "tblTABLE_NAME","C:\Untitled\MyFile.xls", True





------------------------------------------------------------------------------
Ambition..........If you dont use it, you wont lose it