Exporting Queries, Macros and Forms in bulk

[ChuckW]

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

 

[Douglas J. Steele]

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.

 

[Ken Snell [MVP]]

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

 

[ChuckW]

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

 

[Douglas J. Steele]

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.

 

[Bruce]

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.