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

replacing tables in access

P: n/a
Hi,

I currently have a five table and query system created in access.
Basically the structure is fixed. But I have to run the query over
numerous times using different updates of the tables.

Four of the tables need to be replaced before I redo each query run.
Rather than importing each of the four tables individually each time
before I do a run, is there some way that I could just put all the
tables per run in some folder and create a macro that will automatically
replace each of the access tables with the corresponding update tables
in the folder?

It would be good to be able to do this as I'll have to run this same
query very many times, and it would be good to be able to replace all
the tables in one shot.

Thanks.

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 14 Oct 2004 22:28:46 GMT, dan graziano <d3********@hotmail.com>
wrote:

If referential integrity is not an issue in your app, DoCmd.Transfer*
may be your friend.

-Tom.

Hi,

I currently have a five table and query system created in access.
Basically the structure is fixed. But I have to run the query over
numerous times using different updates of the tables.

Four of the tables need to be replaced before I redo each query run.
Rather than importing each of the four tables individually each time
before I do a run, is there some way that I could just put all the
tables per run in some folder and create a macro that will automatically
replace each of the access tables with the corresponding update tables
in the folder?

It would be good to be able to do this as I'll have to run this same
query very many times, and it would be good to be able to replace all
the tables in one shot.

Thanks.

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 13 '05 #2

P: n/a

Tom,

Thanks again for the reply. I'm afraid I'm a real newbie to this, how
would DoCmd.Transfer* work - is this a code I need to create?

In fact, is sql or visual basic macro a possible way to do this?

Thanks for the clarification.

Dan
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.