Using ADO to run an action query from excel
 

I need to run an action query to make a table with data from another
database, using VBA is it possible to do this as I keep getting an error?.
TIA
Charles

Using ADO to run an action query from excel
 

You should be able to use any SQL statement supported by your database/ODBC
driver, and that usually includes action queries. But keep in mind your
database login (user ID, password) needs to be Admin level or at least have
permission to modify the db structure if you want to do a make table query.
Beyond that cannot comment without seeing your code and knowing what the
error message is and where it occurs.
--
- K Dales


"vqthomf" wrote:

I need to run an action query to make a table with data from another
database, using VBA is it possible to do this as I keep getting an error?.
TIA
Charles