Executing SQL from Cross Tab Wizard in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top