Imported spreadsheet data from Excel to Access

G

Guest

If I imported data from an excel spreadsheet to an Access Table and that
table is already linked to other tables and is already in use (it has records
of data associated with it), is there any way I can update that table by
importing the same spreadsheet with the updated data without deleting all the
existing related records for it? Will this work better if it's a linked table?
 
J

John Nurick

Hi Neesah,

If the data in the updated spreadsheet supersedes all the data in the
existing table, then it's often best to use a linked table instead of
importing the data. Then when the spreadsheet is updated all you have
to do is to re-link the linked table.

If the data in the updated spreadsheet supplements or updates the data
in the existing table but does not contain everything that is in the
existing table, you still need to use a linked table to access the
updated spreadsheet. But you then use queries, typically (a) an append
query to copy new records from the linked table to the existing table,
and (b) an update query to update existing records to match the
updated spreadsheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top