Access2007: Import Error; worked in 2003

P

Phil Hellmuth

I have an import spec that worked fine in Access2003 (Import a fixed
width .txt file into a linked SQL table). However, in 2007, it doesn't
work. When executing via the TransferText command in VBA, only one
field (out of eight) is imported. When attempting to import via
External Data from the toolbar, then selecting the spec, I get an
'Invalid Argument' error, with no further detail. Using the same spec,
I'm able to import into a new table.

Taking it a step further, I imported that new table into SQL and tried
to import into THAT table, but with no luck. But, if I import again
into the new Access table, I'm successful.

I've seen some posts on various message boards identifying similar
problems, but with no apparent resolutions. I'm desperate. HELP!!!!

Thanks in advance.
 

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

Using Access 2003 Import Specs in 2007 0
Import .xml with a macro 4
Access 2000 database Import Spec not working properly 1
Error while import Excel file to Access 6
Import text file with macro - Invalid argument (Error3001) 0
import csv conversion & import spec error 1
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported. 0
Importing Excel Data - Error Message 3

Top