Import text file with macro - Invalid argument (Error3001)

N

neil_r

I have a macro that uses Action: TransferText with Transfer Type: Import
Fixed Width. It uses a Specification I've been using for years and still
runs fine. I now need to change the specification but using a newly created
spec causes an Invalid argument (3001) error when I import via a macro.

I can manually import the text file using the new spec but it won't work in a
macro. Even doing a Save As off the old spec (without making any changes at
all) to a new spec name triggers the same invalid argument, but again I can
import manually without a problem.

I'm running many different Access 2002-2003 databases in 2007 and am hesitant
to start converting them all to 2007.

I run this macro several times throughout the day and need a fix besides
manually importing the file.
 

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

Top