TransferText

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've got a problem using the DoCmd.TransferText method in trying to import
data from a .csv file into existing table. My line is as follows:

DoCmd.TransferText acImportDelim, , "Destination_TABLE",
"C:\sourcefile.csv",True

The data in the sourcefile is comma delimited. However, the system doesn't
seem to recognize that which can be seen from the error description. Can I
somehow specify in the TransferText method that the sourcefile is comma
delimited or is there any other way to get this done?

Best Regards,
Marko Utriainen
 
Hi,
you can try to create import specification (just run import from menu file,
define one and save it) and then use this specification as a second argument
 
Back
Top