Hi
Does anyone know how to create a macro in VB in MS Excel in order to import a column of data from a query in MS Access into a specified region in an Excel spreadsheet? I do not know VB at all so any help with the basic code for the macro would be really appreciated. I know how to import external data using MS Query however it is a long-winded process...I really need a simple way, ideally using a command button in Excel, which has a macro behind it (this is where I need the help), which when clicked imports the data from the query in Access into a specified region.
Is there such a thing as an Import Wizard that could do the importing of data in a quick and simple way, via use of a command button?
Thank you for any help.
MH
Does anyone know how to create a macro in VB in MS Excel in order to import a column of data from a query in MS Access into a specified region in an Excel spreadsheet? I do not know VB at all so any help with the basic code for the macro would be really appreciated. I know how to import external data using MS Query however it is a long-winded process...I really need a simple way, ideally using a command button in Excel, which has a macro behind it (this is where I need the help), which when clicked imports the data from the query in Access into a specified region.
Is there such a thing as an Import Wizard that could do the importing of data in a quick and simple way, via use of a command button?
Thank you for any help.
MH