Impoting Excel file into Access

[only412c]

I am trying to import Excel97 and Excel 2000 files into access but somehow it keeps going to the Error routine, when the DoCmd.TransferSpreadsheet is encounter. Below is the the method I am using.

MCOWAdata is the name of the Access table
Me.namedfile is the variable used to capture the file name after user uses browses through the directory. The Excel file does not have any headings.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "MCOWAdata", Me.namedfile, False


Is there anything else I should add? Am I using the right format for the DoCmd TransferSpreadsheet?

Thanks in advance,

JL[\b]

 

[vbajock]

Me.namedfile should be me!namedfile

 

[only412c]

Thanks,

I used the ! but still get me to the error routine.

 

[vbajock]

What is the error?

Another thing you can do is to set up transfer text as a macro and test it. You could then convert to VB after you get it working.