Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning the result of an SQL/Query to Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Not returning formula result | Excel Discussion (Misc queries) | |||
Excel Average function not returning expected result | Excel Worksheet Functions | |||
Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
Returning data to Excel sheet from MS query | Excel Discussion (Misc queries) | |||
Excel 2000 Web query not returning all Table Data | Excel Programming |