|Forum Topic||Post Reply Login|
Automate Getting To Ms Query Wizard
Rate this:(3/5 from 3 votes)
I use MS Query Wizard in excel to manipulate data based out of a MS Access File. The process is currently manual, I go to the Excel >> Data Ribbion > Get External Data >> From Other Sources >> From Microsoft Query > Check the "Use the Query Wizard to create/edit queries" >> Select MS Access Database* (in the Databases tab) >> find the file located in a specific path >> hit OK and then the wizard pops up!
Is there anyway to AUTOMATE this whole process? I would like to click a button on the Ribbon which does all this in the background and when it done pops up with the Wizard so i can build my query!
Thanks for your help!
|Posted by PraveshG81 on|
|Replies - Displaying 1 to 2 of 2||Order Replies By: Most recent | Chronological | Highest Rated|
We can export the data from Microsoft Excel to Microsoft Access by using VBA. Below is the VBA code and process which you need to paste in the code module of the file.
Rate this:(4/5 from 2 votes)
|Posted by jerry_maguire on|
There are two main options to access the MS Query Wizard more efficiently.
Rate this:(3.5/5 from 2 votes)
|Excel Business Forums Administrator|
|Posted by Excel Helper on|
|Displaying page 1 of 1|
|Find relevant Excel templates and add-ins for Automate Getting to MS Query Wizard in the Excel Business Solutions Directory|