| 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 | |||
![Hans Weustink[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
