Importing to existing table

  • Thread starter Thread starter B McGill
  • Start date Start date
B

B McGill

How can I append date from a spreadsheet to an existing
table?

I have a table called "Lanes" which I need to export to
Excel to make some changes that can only be made quickly
through excel. But how do I get the data back into the
original table with the corrections made?

Thanks for your help.
 
This is the hard way to do this. You could use an Update query to update the
table's results from the EXCEL spreadsheet (link the spreadsheet as a
table). Or you could delete all the records from the table and import the
EXCEL's data into the table.

Or just use a form to make the changes to the table's data. This will be
much safer and easier. Moving between ACCESS and EXCEL can cause undesirable
changes to data formats that are not easily reversed.
 
Back
Top