Executing SQL from Cross Tab Wizard in VBA

L

Leo

Hi -

Any idea why the SQL queries that are created by the Cross Tab Query Wizard
cannot be ran in VBA?

It starts off with the 'TRANSFORM' statement, as opposed to the usual
'SELECT' statement
IS this the reason why? Or is it because I have 'PARAMETERS' defined in the
SQL statement?

How would I ran a Cross Tab query in VBA?

Please Advise
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display zero value in blank fields of Cross Tab query 0
CrossTab Query (SQL View) in VBA 2
cross tab 1
Using automation to load a cross tab query to Excel 12
How do I execute multiple SQL statements in Access?? 3
Query question 3
access report on a cross tab query 2
SQL query 1

Top