TransferText

[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

 

[Alex Dybenko]

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