replace .xls with access table

[Lanason]

I have a linked excel spreadsheet to my database but now I want to IMPORT the data into an access table

The spreadhseet is linked to queries - what is the correct sequence to replace the linked excel with the new table?

 

[plog]

You shouldn't have to touch any query. Let's call the table object that is the linked spreadsheet "Data1".

1. Make a backup of your database. This is always step 1 in whatever you do.

2. Import the spreadsheet's as a new table using the import tool. Name this table "DataNew".

3. Copy "DataNew" and paste it as a new table with the name "Data1"--replacing the existing object.

4. Delete "DataNew" and everything should work as it did before.