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]

Re: Table append

"Kevin" <kevcar40@btint ernet.com> wrote in message
news:9f8487f2.0 503140435.5d10c 95a@posting.goo gle.com...[color=blue]
> 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[/color]


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@hotmail.com]

Re: Table append


Kevin wrote:[color=blue]
> 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[/color]

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.OpenQuer y
"qappNewRecords "), and then turned the warnings back on.

[Kevin]

Re: Table append

thanks both

pietlinden@hotm ail.com wrote in message news:<111082010 1.788491.275170 @l41g2000cwc.go oglegroups.com> ...[color=blue]
> Kevin wrote:[color=green]
> > 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[/color]
>
> 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.OpenQuer y
> "qappNewRecords "), and then turned the warnings back on.[/color]