Automated exporting 100s of queries to another DB

[BK Waas]

I have more than a hundred queries that I must export from one MDB file to
several other MDB files.

I have tried to use the Macro-building tool. But when I select "RunCommand"
as the action and "Export" as the command, there does not seem to be any
place for an argument that would specify the name of the query that I want to
export.

How can one automate this process? I have to think that it's fairly
straightforward. Thanks.

 

[Jeff Boyce]

If the data that is contained within DB1 must be seen from within DB2, DB3,
...., why not link to the tables in DB1 from those other DBs? This would
allow you to put the queries inside the DBs that need the queries, with NO
exporting!

Or am I missing something...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Cringing Dragon]

This may differ with different version of Access. I only have Access 2000.

Use the Action "TransferDatabase".
This gives you a number of parameters, the first of which is Transfer Type
(needs to be Export in your case), and another is Source.
I'm sure you can figure it out from there.

NB building this as a an Access "Macro" could get almost as tedious as
exporting manually. If you've had any exposure to Visual Basic for
Applications (VBA), I'd consider using an Access "Module" instead.