Can't Import CSV File Into Linked Table

  • Thread starter Thread starter John Lane
  • Start date Start date
J

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.
 
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.
Click to expand...

I'd suggest linking to the CSV file and running an Append query into
the linked table.
 
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.
 
Back
Top