Why wont my VBA code for Importing an Execl 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 to fill in differencnt access versions (i.e. acSpreadsheetTypeExcel8) but everytime I click the import button on my form, nothing happense. what am I doing wrong???

 

[SkipVought]

hi,

Your best place for MS Access VBA is forum705.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}