Import text file with macro - Invalid argument (Error3001)

Discussion in 'Access Macros' started by neil_r, May 21, 2010.

  1. neil_r

    neil_r Guest

    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.
     
    neil_r, May 21, 2010
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.