Exporting Queries, Macros and Forms in bulk

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChuckW - 11 Sep 2004 21:16 GMT

Hi,

I have an Access app with hundreds of forms, macros,
queries and reports. I want to export them all to
another access application. Is there a way to do this in
bulk? Right now I am exporting them one at a time.

Thanks,

Chuck

Reply to this Message

Douglas J. Steele - 11 Sep 2004 21:26 GMT

Are you doing this manually or programmatically?

Manually, you can multi-select and then export them all.

Programmatically, you have to export them one at a time, but you can create
loops that determine the name of each form, macro, etc. and so export them
all that way.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
>
[quoted text clipped - 6 lines]
>
> Chuck

Reply to this Message

ChuckW - 11 Sep 2004 21:44 GMT

Douglas,

Thanks for your help. I am doing this manually. What are
the specific steps to multiselect something? Whenever, I
click File => Export, it seems to only allow one query or
one form at a time. How specifically do I select all
queries or all forms and then export them at one time?

Thanks

Chuck

>-----Original Message-----
>Are you doing this manually or programmatically?
[quoted text clipped - 17 lines]
>
>.

Reply to this Message

Douglas J. Steele - 11 Sep 2004 23:47 GMT

Sorry: I wasn't thinking clearly when I posted.

You can't export using multiselect. As Ken posted, you need to import into
your new database (File | Get External Data | Import). You can multiselect
there.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Douglas,
>
[quoted text clipped - 34 lines]
> >
> >.

Reply to this Message

Bruce - 13 Sep 2004 03:26 GMT

I too wish Microsoft Access had some way to Export that
wasn't one at a time. What both replies haven't mentioned
is that when you go to the destination db and Import, if
you already have those hundreds of objects (forms,
queries, etc), you will end up with double the objects,
because Import will just stick 1 on the end. So if you
have FormA, FormB, etc, after you Import them you will
have FormA, FormA1, FormB, FormB1, etc. And then you'll
have to go through and delete all the 1's.
The only way to do it is to write a program to do it. I
get around it by having my data db separate from my app
db, and when I need to Export more than a handful of
objects, I just take the whole app mdb.
S'pose we should be grateful for multiple Import, old
versions of Access didn't even have that.

Bruce.

>-----Original Message-----
>Sorry: I wasn't thinking clearly when I posted.
[quoted text clipped - 39 lines]
>> >>
>> >> Chuck

Reply to this Message

Ken Snell [MVP] - 11 Sep 2004 21:29 GMT

Open the new ACCESS database and do an import of all the objects. You can
select all of them or some of them.

Signature

Ken Snell
<MS ACCESS MVP>

> Hi,
>
[quoted text clipped - 6 lines]
>
> Chuck

Reply to this Message