Can't Import CSV File Into Linked Table

[John Lane]

I'm trying to import and append a csv file into a linked tabe using Access
2007. Of course I am having problems. I get an error message saying "Invalid
Argument" with no explanation. If I put the table in the same mdb it imports.
Is there a known bug now that you can't import into a linked table? Thanks.

 

[John W. Vinson/MVP]

I'm trying to import and append a csv file into a linked tabe using Access
2007. Of course I am having problems. I get an error message saying "Invalid
Argument" with no explanation. If I put the table in the same mdb it imports.
Is there a known bug now that you can't import into a linked table? Thanks.

I'd suggest linking to the CSV file and running an Append query into
the linked table.

 

[John Lane]

Good idea! Thanks! I later figured out that the import worked - for some
reason it generates an erronous error message, and none at all if I run it as
a DoCmd.TransferText. Also, it seems to muddle up the "File has Column Names"
checkbox. Other than that, it worked fine.