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

importing specific records

P: n/a
Hi,

In order to keep the file that's in development up to date with the
reference (and still used) file, I need to regularly import the
original main table and then physically select and append the imported
records into the table I am working on. Is it possible to import
specific records from the main table? At the end of each day, I'd like
to import and append the new records from the current table in the one
I am working on. Is this possible?

Regards,
Stinky Pete ;-)

Sep 5 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Could you make an Append query with both tables linked by a no duplicates
ID?
That way the query will only append missing records as it will not allow
duplicates in the ID.
I think this is what you are trying to do, I hope this is helpful.

"Stinky Pete" <Pe**********@symbionhealth.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
Hi,

In order to keep the file that's in development up to date with the
reference (and still used) file, I need to regularly import the
original main table and then physically select and append the imported
records into the table I am working on. Is it possible to import
specific records from the main table? At the end of each day, I'd like
to import and append the new records from the current table in the one
I am working on. Is this possible?

Regards,
Stinky Pete ;-)

Sep 5 '06 #2

P: n/a
Hi Pete,

Could a linked table be the way to go possibly?

Good luck,

Nick

Stinky Pete wrote:
Hi,

In order to keep the file that's in development up to date with the
reference (and still used) file, I need to regularly import the
original main table and then physically select and append the imported
records into the table I am working on. Is it possible to import
specific records from the main table? At the end of each day, I'd like
to import and append the new records from the current table in the one
I am working on. Is this possible?

Regards,
Stinky Pete ;-)
Sep 5 '06 #3

P: n/a
use the find unmatched query wizard and turn it into an append query?

Sep 5 '06 #4

P: n/a
Thanx to all who've replied with comments. Dopey did not think of
linking the tables (Doh!) and the append with unique ID bit is great.

I try thinking before posting next time ;-)

Stinky Pete ;-)

pi********@hotmail.com wrote:
use the find unmatched query wizard and turn it into an append query?
Sep 5 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.