Executing SQL from Cross Tab Wizard in VBA

G

Guest

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
 
G

Guest

I meant: How would I run an SQL statment created by the cross tab query
wizard in VBA?
 

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

CrossTab Query (SQL View) in VBA 2
Using automation to load a cross tab query to Excel 11
Query question 3
cross tab query - group by week 6
Format column headings in Cross-Tab 1
SQL question - Cross Tab query 2
IIF in crosstab 1
Expression Error on Parameter Query with link to Cross Tab Query 8

Top