Macro for Running Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
 
Back
Top