By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,206 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

Table append

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"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.
Nov 13 '05 #2

P: n/a

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.

Nov 13 '05 #3

P: n/a
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.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.