ADODB.Connection
 

Hi, Please help...

I am trying to use the ADODB.connection to link Access to Excel via VB code.
I have written a query which is a crosstab query to pull data through. My
problem is that it doesnt seem to like anything I write to pull data back. my
query starts with "TRANSFORM.... Is this correct or should I be using
something else?

Thanks,
Jez