Importing only NEW RECORDs in MS-Access!

[TheElectron707]

Hi! I have a scenario in which i am importing a VERY LARGE database
over the network. (Linking is not my solution). Now it takes many
hours to import the complete database. I want that once the whole
database has been imported, next time when i import only the NEWER
records come in (almost database refresh every 24hours) so that the
time taken is much much smaller and the network donot get chocked for
many hours daily.

Any solution would be helpful?

[DFS]

"TheElectron707" <Th************@yahoo.com> wrote in message
news:a1**************************@posting.google.c om...

Hi! I have a scenario in which i am importing a VERY LARGE database
over the network. (Linking is not my solution). Now it takes many
hours to import the complete database. I want that once the whole
database has been imported, next time when i import only the NEWER
records come in (almost database refresh every 24hours) so that the
time taken is much much smaller and the network donot get chocked for
many hours daily.

Any solution would be helpful?

Electron,

If linking isn't a solution, you need to some way to define which records
are "new" and typically that's a date or timestamp. You don't say what
format the records are in or how you're importing them, but if the source
data is in text files you could write some VBA code to open the files and
iterate through the records, checking the date/time, and import only the new
records. Or you could look at this problem from the data source side: what
system is producing all this data for you to import. Can this source system
produce only new data for you?

[Pieter Linden]

Sounds ripe for a "Find Unmatched" query, and import those. Except
that assumes that you're only importing NEW records, not CHANGED
records.