Macro for Running Queries

[Guest]

Is there a way to create a macro to runny multiple Append Queries? I actually have 5 append queries and 1 Update query I need to run and it is too time consuming running each one separately

Also
Is there a better explanation for importing a text file using a macro? I can't get it to work correctly. Should I use VBA instead and import the data using a form? If I should use the form and VBA is there a good source of info on teaching me how to do this

Thanks in advance

John

 

[Jim/Chris]

Create a macro with 6 RunQuery actions.

Create an import specification by clicking on the advanced
button in the File/Get External data. Once you have
selected the text file the advanced button will appear.
Here you can modify and save your import specification.
Create a macro using the TransferText Action and use the
Import specification you just created.

Jim

-----Original Message-----
Is there a way to create a macro to runny multiple Append

Queries? I actually have 5 append queries and 1 Update
query I need to run and it is too time consuming running
each one separately.

Also,
Is there a better explanation for importing a text file

using a macro? I can't get it to work correctly. Should
I use VBA instead and import the data using a form? If I
should use the form and VBA is there a good source of info
on teaching me how to do this?