importing specific records

[Stinky Pete]

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 ;-)

[Mark W]

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 ;-)

[Nick 'The database Guy']

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 ;-)

[pietlinden]

use the find unmatched query wizard and turn it into an append query?

[Stinky Pete]

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?