Updating table from external source

[DianaW]

Dear Forum,

I have a question and I would be very happy if you could help me with some thoughts on how to start.

I have a database, which contains one table tbX, which ist interesting in this context. tbX needs to be updated on a regular basis, hence it would be very helpful to automate this process.

Source is the table tbY, which is located in another database in a different directory. What I am looking for is basically a query (or do I need a macro?), which deletes tbX, imports tbY and changes its name to tbX.

As there is no macro recorder like in Excel I find it very difficult to find a start here...

I'd be happy for any suggestion.

Thank you.
Diana

 

[neileg]

If tby is always available, then you can link to it instead of importing the data. Your problem no longer exists!

 

[Dennisk]

the standary processes for import are :-

create an import file.

then every time you import

1) delete contents of import file
2) import data to import file
3) validate the imported data.
4) Update main table.

 

[DianaW]

Problem solved. Thank you!

Thank you neileg and DennisK for your contributions. Yes, tbY always exists and thus I can link the tables as suggested by neileg.

BTW - when searching for some background on how to link tables I found this very helpful explanation: http://www.techonthenet.com/access/tables/link_table.php

Thank you for your help.
Diana