Import Excel to Access back-end data file

[Denise]

I need to import about 500 Excel records into an Access
2000 back-end data table. I tried to complete the import
from the front-end files and can't because Access will not
let me select an existing table. However, when I open the
back-end file and import at that point everything works.

This is a multi-user database that is critical to the
successful operation of the company. Any suggestions for
importing without putting the back-end data tables at risk
to be deleted or corrupted?

 

[John Nurick]

Hi Denise,

If there isn't already one, create a linked table in the front end
linked to the relevant table in the back end.

Then link or import the Excel sheet to a new (temporary) table.

Finally use an append query to move the data from the temporary table to
the main table, and delete the temporary table.