Table append

[Kevin]

Hi
I have a table that is imported from excel
the records are updated as required by the user

my question is
Can only the new data entered be appended to the table in access
ie if i update the table in the morning and import 10 records
when i next update the table i want to import only the new data

any help would be welcome

thanks

kevin

[Justin Hoffman]

"Kevin" <ke******@btinternet.com> wrote in message
news:9f**************************@posting.google.c om...

Hi
I have a table that is imported from excel
the records are updated as required by the user

my question is
Can only the new data entered be appended to the table in access
ie if i update the table in the morning and import 10 records
when i next update the table i want to import only the new data

any help would be welcome

thanks

kevin

An easy non-code solution is to create a linked table to the spreadsheet,
then base a query on the two tables which only displays the records in the
spreadsheet which do not have a matching entry in your local table. The
append query takes only these records.

[pietlinden]

Kevin wrote:

Hi
I have a table that is imported from excel
the records are updated as required by the user

my question is
Can only the new data entered be appended to the table in access
ie if i update the table in the morning and import 10 records
when i next update the table i want to import only the new data

any help would be welcome

thanks

kevin

Like Justin said, you could link your Excel table (File, get external
data, link tables...) and then use the find unmatched query wizard.
Once you've done that, you could turn your query into an append query.
if you wanted to go really nuts, you could write a macro that shut the
warnings off (Set Warnings=False), ran the query (DoCmd.OpenQuery
"qappNewRecords"), and then turned the warnings back on.

[Kevin]

thanks both

pi********@hotmail.com wrote in message news:<11**********************@l41g2000cwc.googleg roups.com>...

Kevin wrote:

Hi
I have a table that is imported from excel
the records are updated as required by the user

my question is
Can only the new data entered be appended to the table in access
ie if i update the table in the morning and import 10 records
when i next update the table i want to import only the new data

any help would be welcome

thanks

kevin

Like Justin said, you could link your Excel table (File, get external
data, link tables...) and then use the find unmatched query wizard.
Once you've done that, you could turn your query into an append query.
if you wanted to go really nuts, you could write a macro that shut the
warnings off (Set Warnings=False), ran the query (DoCmd.OpenQuery
"qappNewRecords"), and then turned the warnings back on.