View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Returning the result of an SQL/Query to Excel

Have you tried setting up a querytable using Data=Get External Data?

--
Regards,
Tom Ogilvy

"Hans Weustink" wrote in message
...
Hi,

I would like the result from a query to be returned to an
excel sheet. I can get the database connection=, but
that's it.

So to run a query within Excel based on a SQL with the
results in a predetermined sheet or just Sheet1,2,..

Thanks,
Hans Weustink