469,610 Members | 1,862 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

Importing only NEW RECORDs in MS-Access!

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?
Nov 12 '05 #1
2 1801
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?
Nov 12 '05 #2
Sounds ripe for a "Find Unmatched" query, and import those. Except
that assumes that you're only importing NEW records, not CHANGED
records.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Joel | last post: by
1 post views Thread by Thomas R. Hummel | last post: by
5 posts views Thread by BeruthialsCat | last post: by
3 posts views Thread by Donald Grove | last post: by
reply views Thread by Mike Collins | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.