Results 1 to 2 of 2
  1. #1
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328

    Import spec doesn't exist error

    To import a csv file I have written code:

    DoCmd.TransferText acImportDelim, "99RN", "T_CYC", RNpath & "" & RNfile, True, ""

    I get a message "Error 3625 99RN doesn't exist etc."

    I go back, redo the import manually and try to name it 99RN and get a message that I can't name it 99RN as that spec name already exists.

    Any ideas? Driving me nuts.

  2. #2
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    I got it. It appears that naming a spec on the last screen while importing is a useless maneuver. Not sure why it is offered or what it does. To refer to an import spec name in vba, you must click the Advanced button while setting up the import procedure. Then, name the spec and save it on the advanced screen. VBA just doesn't recognize the other name. Strange.



    Quote Originally Posted by gg80 View Post
    To import a csv file I have written code:

    DoCmd.TransferText acImportDelim, "99RN", "T_CYC", RNpath & "" & RNfile, True, ""

    I get a message "Error 3625 99RN doesn't exist etc."

    I go back, redo the import manually and try to name it 99RN and get a message that I can't name it 99RN as that spec name already exists.

    Any ideas? Driving me nuts.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 01-25-2016, 01:36 PM
  2. My import spec skips first record
    By Mikey1987 in forum Access
    Replies: 2
    Last Post: 12-01-2015, 06:49 AM
  3. Replies: 2
    Last Post: 03-13-2015, 09:11 AM
  4. Import spec saved
    By crowegreg in forum Import/Export Data
    Replies: 6
    Last Post: 02-17-2014, 04:11 PM
  5. Replies: 19
    Last Post: 08-08-2013, 01:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums