Annoying Error When Trying to Reload Excel Database

squeakums

Well-known Member
Cannot Define field more than once

and

The specification failed to execute. Try re-creating the specification

I am simply trying to reload an excel file with the updated one, I've done it before no errors. I even removed the Auto Numbered ID and reran the load, same issue.

if not this error I get that annoying cannot duplicate.. etc.

How can I load my table again please? It would just be more frustrating if it disappears since I have multiple forms linked to it.
 

xenou

MrExcel MVP, Moderator
Hard to say without seeing any data. You probably have some problem in the file or the target table. Don't panic - just start with the basics and work the problem one step at a time. Is the data clean? Are the fields all defined correctly with correct data types? Are their blank rows or columns? Are there mixed data types in one column? Does the target table match the Excel table? Is the import specification correct? If worse comes to worse, remove half of the columns and see if the "first half" loads okay. Then try with the second half - narrow down the problem. Or just try loading everything as text to a new table to see if you can load the data with minimal constraints.
 

squeakums

Well-known Member
Thank you for replying. I'm a pro at excel, but when it comes to Access, it really does hate me. I haven't used it on over 5 years. But, now I'm in the process of create an ad hoc form with a combo box. It has been a true nightmare.. The loads worked and so I saved an autoload. I have tried running it fresh without the autoload. Definitely in panic mode since.. I have been working on the form links for weeks. If I remove the load and reload the file, will it corrupt my forms or can I simply relink them?
 

xenou

MrExcel MVP, Moderator
I'm not familiar with the terms "saving an autoload" or "removing a load". Access has an import wizard. Is it something like that? From my experience with Access you can relink data sources at any time.
 

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top