Home >> Support Center >> Support Library

• »Training Center
• »Support Library
• »Downloads
• »Toolbox Mailing List
• »Submit Support Ticket

Import Tool Data Load Error Troubleshooting

PRINT

Have you ever been performing an import and gotten an error message like this:

Figure 1

Occasionally MS Access creates temporary tables and indexes and the Import Tool will “choke” on them.  the best way to get around this is by creating a new Access file and importing your data to it.  this will ensure that you’re working with a clean file. To create a new Access file and import your data to it follow the steps below.  In this example I’ll import a table called “blah” from an Access file called “sync.mdb.”

1.) Open the folder where the original import file resides and right click in a blank space, browse to “New” in the menu and then select “Microsoft Access File” from that menu, as shown in figure 2.

figure 2

2.) Next, open the new Access file and right click the “Table” button (Figure 3) and select “Import” from the list.

Figure 3

3.) Browse to your original import file and double click it to open it.

Figure 4

4.) When you’ve opened that file you’ll see a new dialog box called “Import Objects” (Figure 4).  Select the table you want to import and then click “OK.”

Figure 5

You’ll now see a copy of the table from your original import file in your new Access file, ready for import.