Results 1 to 5 of 5

Importing Table Cannot Define field more than once 3191

  1. #1
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    177

    Importing Table Cannot Define field more than once 3191

    I took a look at this table to look for any duplicate fields. I didn't see any duplicates in the table. It also has a sub datasheet. Could that be the Issue? Is anyone familiar with some solutions to solve this issue? It seems there is no issue in the table when I look at it in another database. Is there anything I can show people that will help you understand my issue better? Could there be an issue with the import specs? Any help would be appreciated.

    Thanks,


    Nick

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,540
    usu, the spreadsheet has 2 fields w the same name somewhere....

    Name, Addr, City, Addr, State

  3. #3
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    177
    Here are all the fields in the table.

    ContainerBOL
    BOLdate
    Container
    DateStamp
    Orien
    SW/LCL
    Demension
    Cube
    ETA DC
    ID
    Forworder
    Vessel
    Mode
    Logistic Report Comments
    Sort Type
    Run
    DC Arrive Date
    @Port
    @Train
    @Chicago
    @CColumbus
    Carrier
    Manifest
    WE
    Pick Up@CFS
    Ocean-Air Line
    Port
    Seal Number
    Sail/Flight Date
    Costs
    Arrive Time
    Trailer Number
    City
    State
    Date/TimeOfUpdate
    PreAlert@Port
    PreAlert@CMH
    2PortETA
    CustomsSubmitted
    CustomsCleared
    Update
    Voyage
    OBL#
    WestCoast Comments
    Lost
    InvoiceDate
    InvoiceNo:
    LinkedField
    Date/Time-Stamp
    Hose
    PrePaid/Collect
    ZipCode
    Ctns
    Vendor
    ReportNumber
    SubContainer
    InvoiceComments
    Estimated Costs
    Delete
    Lbs
    CFS
    MEF#

    We have been using this table for a while. So it is weird to have an issue like this.
    Attached Thumbnails Attached Thumbnails C-1FieldsPage1.png  

  4. #4
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    177
    I was able to export it manually on my local computer from one local copy to another local copy without any problems. I didn't name it that new destination table name. As soon as I run the vb code it come with that error. Could the database be corrupted possibly?

  5. #5
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    6,835
    its quite possible that the use of non alphanumeric characters (@#/-), reserved words (container, update, delete, perhaps others) in your field names and starting them with a numeric value is causing a misleading error. i.e. you have an error, but the message is pointing you in the wrong direction. So perhaps you have made a change somewhere, using the table for something else or just have some duff data which is creating the error.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-06-2018, 10:58 AM
  2. Replies: 4
    Last Post: 07-29-2015, 05:30 AM
  3. How to define field types in a make table
    By accessmatt in forum Queries
    Replies: 3
    Last Post: 07-09-2015, 10:54 AM
  4. Replies: 1
    Last Post: 01-28-2015, 04:13 PM
  5. Cannot define field more than once
    By btk10 in forum Access
    Replies: 1
    Last Post: 10-23-2013, 07:15 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
  •  
Tech Forums: Microsoft Office Forums