adding data to a table from an excel spreadsheet

  • Thread starter Thread starter Lynn atkinson
  • Start date Start date
L

Lynn atkinson

I have data already in a table in Access. I want to
populate more fields in that table with data which exists
in an excel spreadsheet. How do I add data to existing
records rather than adding records to the table?
 
The hardest bit is to sort the records in Access the same way as the records
in Excel... so that record 1 Access matches record 1 Excel, etc., but let's
assume you have done this. Add the new fields to the table, and show them,
which should be blank. Select the cells in Excel and copy them, select the
same fields in Access and paste them...

HTH.

Tom.
 
Up to the part about copy paste, I would agree.
Once you have the structures aligned you import the Excel spreadsheet to a
staging table and then write an Update query to add the data to existing
rows.
--
Joe Fallon
Access MVP



The hardest bit is to sort the records in Access the same way as the records
in Excel... so that record 1 Access matches record 1 Excel, etc., but let's
assume you have done this. Add the new fields to the table, and show them,
which should be blank. Select the cells in Excel and copy them, select the
same fields in Access and paste them...

HTH.

Tom.
 
Back
Top