If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Executing SQL from Cross Tab Wizard in VBA
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 |
#2
|
|||
|
|||
I meant: How would I run an SQL statment created by the cross tab query
wizard in VBA? "Leo" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inconsistent square bracket in Query SQL | Christine | Running & Setting Up Queries | 8 | October 7th, 2004 03:49 AM |
Using sql insert with memo field truncates text data | Graham Meredith | General Discussion | 1 | September 1st, 2004 03:11 AM |
Function isn't available in expressions in query expression | Reiner Harmgardt | General Discussion | 4 | July 21st, 2004 09:30 AM |
Problem accessing SQL Server in upsizing wizard | Edward | General Discussion | 1 | July 5th, 2004 06:00 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |