Results 1 to 2 of 2
  1. #1
    bmalex1 is offline Novice
    Windows 7 Access 2007
    Join Date
    Apr 2010

    3127 error in FTP import


    I recently inherited a job bthat requires me to update a db with a function that merges ftp data from a txt.file. I get an error msg that reads.....

    The INSERT INTO statement contains an unknown field 'Unused0". Make sure you have typed the name correctly and try again.

    Can someone pleas tell me how to fix this?

    I am new to access but I know this means something is wrong with a field, somewhere in the script. I just don't know where to look.

    I have searched the script for Unused0 and it's not there. I have matched the tables headers in all of the tables that are being updated.

    I still get the same error.

    Also, I understand that someone may need more information, in order to put me in the right direction. Any assistance would be appreciated.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    Yes...a little more information would be helpful. How about posting the function for us?

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

Similar Threads

  1. Import XML file
    By randolphoralph in forum Programming
    Replies: 1
    Last Post: 01-22-2010, 09:12 PM
  2. VBA Import Error on Invalid Characters
    By jhrBanker in forum Import/Export Data
    Replies: 2
    Last Post: 11-25-2009, 12:07 PM
  3. CSV vs XLS Import
    By Betty Boop in forum Import/Export Data
    Replies: 1
    Last Post: 10-27-2009, 07:10 AM
  4. How would I import something like this?
    By Insyderznf in forum Import/Export Data
    Replies: 13
    Last Post: 08-10-2009, 05:18 PM
    By fadone in forum Import/Export Data
    Replies: 2
    Last Post: 04-20-2006, 06:36 AM

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