Importing one set of data on top of another

[JamesLynch]

Thank you FancyPrairie for your early suggestion, it worked a treat.

Now for my latest question.
I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc.

With the exception of cutting and pasting the following days records, is there any way to include the both days records together without over writing the first?

Using some sort of automated repoprt Perhaps?

 

[chip38]

If your table has an autonumber primary key... you can import the same records again and again and they will append to the table as new records... ie... never overwriting the records you already have. The data can be identical every time... but the records will be added with a new sequence number as the key.

 

[JamesLynch]

In my last query I asked....

I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc.
With the exception of cutting and pasting the following days records, is there any way to include the both days records together without over writing the first?
Using some sort of automated repoprt Perhaps?

Chip38,
Thank you for your suggestion, however it hasn't quite resolved my question.

Is it possible by using the Access function to get extrenal data, to add to an existing table instead of overwriting the previous one or creating a new one.

I run a customer query report on a daily basis and each day have assigneed an autonumber, i.e. 1 to 25.
The following day the Autonumber (which is ALSO my Primary Key)restarts again from "1" as I am technically creating a new table.

Can I manually edit the Autonumber for any secondary day so that Access will think that it is seeing an addition to the last set of data rather than a whole new table?

All suggestions welcome

 

[chip38]

What are you doing to the original table? Deleting it? Or are you making a new table each day with a diff name? If you keep the same table and either transfer the records out or purge it each day, the autonumber will keep increasing. You can use a delete query to purge the records. How I would approach this depends on if you keep using the same table name each day. (Try this... add 3 records... 1, 2, 3... delete them... add a new rec... autonumber will number it rec 4... even tho it's the only rec) Hope this helps.
Chip