Importing External Data - Excel

[maeyks]

Hi,

I have a question, If, from the start, I imported a table from excel into access, is there a way that it will just "continue" its upload thereafter? For example, I uploaded rows 1 to 100 from excel, and upon update of the original excel, I will then update rows 101 to 200.

Thank you very much.

[CJ_London]

the way to do it is

a) your excel data needs a uniqueID of some sort to identify each row
b) rather than import, link to the spreadsheet, or alternatively import to a temp table (I'll assume the former)
c) now write a query left joining your linked table to the existing data on the uniqueiD and setting a criteria for the uniqueID in the existing data of null - this will identify records in your spreadsheet which are not in the existing data
d) convert this query to an append query to append these records tou your existing data