Trying to import text (.csv) into access but fails

[johnawebbhsd]

I am trying to import a .txt or .csv file into access using Macro or VB code. Everything I try I get invalid field error. My table has 4 fields as seen below, seperated by comma. Currently we do this manually by opening the csv w/ xls then manually copy and paste all of these files into access.

Any ideas on how to get around this error?
have tried transferdatabase and transfertext



1234567890,08/14/03,108,108,08/14/03

Thanks,

 

[bat17]

I am trying to import a .txt or .csv file into access using Macro or VB code. Everything I try I get invalid field error. My table has 4 fields as seen below, seperated by comma. Currently we do this manually by opening the csv w/ xls then manually copy and paste all of these files into access.

Any ideas on how to get around this error?
have tried transferdatabase and transfertext



1234567890,08/14/03,108,108,08/14/03

Thanks,

If you use File>Get External Data>Import... to get your file, then in the Wizard select the Advanced button you can set up all the fields for the import and then save the Import specs.
You can use this saved Spec from code to re-import latter

HTH

Peter