Importing Additional Excel records

[Guest]

I have created an Access Database from an Excel spreadsheet. I now need to
update the database with new records in the Excel document. I tried to
import the entire spreadsheet over again but it caused an error and won't
continue. Is there a way to just update the database with the new records?

 

[John Vinson]

I have created an Access Database from an Excel spreadsheet. I now need to
update the database with new records in the Excel document. I tried to
import the entire spreadsheet over again but it caused an error and won't
continue. Is there a way to just update the database with the new records?

I'm sure there is, but it will depend on how your data is stored - in
particular how you define "new". Do you have a Primary Key in the
Access table, corresponding to a field in the spreadsheet? or a
date/time field in the spreadsheet that you can use to identify new
records?

Most likely you'll want to use File... Get External Data... Link to
connect to Excel, and then run an Append query from the linked
spreadsheet into the local table; the query should select only "new"
items - but you know better than I do how to identify which those are!

John W. Vinson[MVP]