View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jez[_7_] Jez[_7_] is offline
external usenet poster
 
Posts: 19
Default 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