Importing CSV file to Access

B

biswajit.tamu

Hi,

I am trying to import a CVS file using following command
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTempUpload", txt_box_file_path & strFileName

It gives me error.. Says external table is not in correct format.

What could be the problem ?

Thanks
BJ
 
B

Biswajit Jena

Hi Tina.

Thanks for your suggestion.
Would you please let me know the complete syntax as I am not able to
use it as you said ?
I am writing :
DoCmd.TransferText acImportDelim, "tblTempUploadWeir",
txt_box_file_path & strFileName

It is expecting a Speccification which I dont know what to do.
 
J

John Nurick

It's not normally necessary to use an import specification for a CSV
file. Omit the SpecificationName argument:

DoCmd.TransferText acImportDelim, , "tblTempUploadWeir", _
txt_box_file_path & strFileName, True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV Import Error 2
Importing Multiple Excel Worksheets into An Access Table 4
Importing Data Error Checking 1
how to import multiple Excel files into multiple Access tables? 9
Excel File won't Import into Access 1
Importing Excel Sheet into Access Database using VBA 2
Import Several excel files into Several Access Tables 6
Exporting Excel workbook to Access table 1

Top