Can't Import CSV File Into Linked Table

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.
 
J

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Doughnut Chart linked with the slicer in the pivot table 0
Cannot import CSV file into ACCESS 1
Import problem into SQL Server 2005 linked table 1
Convert a csv to xls prior to import 2
Access2007: Import Error; worked in 2003 0
Record limit CSV import and more - Access 2002 SP3 1
Import Multiple CSV Files from Same Folder into Open Workbook 5

Top