Gemma
Kinda my thoughts.
After truncating the table, I'm now back to getting the "Invaid Argument"/File not imported" messages, but it DOES import the data.
That's Microsoft for you!
Folks, thanks for the suggestions.
It turned out it WAS importing the data anyway. I found several copies of it in the table after transferring data via a jet version of the table. We then remembered we get this with SQL back ends, and last year, just ignored the invalid argument error...
Hi
Most of the tables are in SQL (though not the new table I tested with and found the extra columns).
The access database file size is 193,376Kb
I use the import text wizard. We do this every day of the week on different jobs.
I even went into Advanced - which can't see the extra...
I regularly import a text file in similar layouts into Acccess 2010. For my latest job, I keep getting Invalid Argument when importing into an existing table. The file is comma separated. If importing it to a new table, it adds two new columns - despite ther being no extra commas in these...