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

Multi Exporting

P: n/a
I have Many Tables, Forms, Queries, etc that I need to export to another Access
Database (Approx. 200). Is there a way to do that without doing it to each
indivisual Table, Form, Query, etc?

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Alan Mars" <no***@home.com> wrote in message
news:Kw********************@newssrv26.news.prodigy .com...
I have Many Tables, Forms, Queries, etc that I need to export to another Access Database (Approx. 200). Is there a way to do that without doing it to each
indivisual Table, Form, Query, etc?


Don't push, pull.

If you import from the destination file you can import all of the objects at
once.
Nov 12 '05 #2

P: n/a
From the new MDB, IMPORT all of the desired objects from the old MDB.

File, Get External Data, Import, Select the Source MDB, then select the
specific tables, forms, queries, etc that you want to be copied into the new
MDB.
Nov 12 '05 #3

P: n/a
Thanks for the info. I don't know why I didn't think of that!

In article <bl**********@inntp-m1.news.aol.com>, ha********@timeinc.com says...

From the new MDB, IMPORT all of the desired objects from the old MDB.

File, Get External Data, Import, Select the Source MDB, then select the
specific tables, forms, queries, etc that you want to be copied into the new
MDB.


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.