Excel Table with SQL Statements to Access via VBA

**learning_vba** · 12-09-2013, 10:44 AM

Hello,

I have an Access VBA challenge I do not know how to overcome. I have an Excel sheet with two columns, Query Name and SQL. Query Name column is obviously the name of the query I would like to create and SQL is the SQL string I would like to put into the created query. Ideally, I would like to avoid having to create a query manually and cut and paste the SQL into the SQL view of Access. I was thinking perhaps I should import this Excel sheet as a new table into Access and then somehow use VBA to loop through all the rows and create a query with the proper name based of 'Query Name' and the proper SQL based of 'SQL'. Any help would be much appreciated.

Thank you,

learning_vba

**xlbiznes** · 12-09-2013, 12:45 PM

Hi,

using ADO in excel and you can connect to a varied source of database including ms access.

**Norie** · 12-09-2013, 12:50 PM

Don't know why you don't want to create the queries in Access manually where you would get help with any errors.

But if you do want to create them in code take a look at Access' QueryDefs collection.