Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel with SQL Query (*.sql) and SQL Server
Hi There,
I have a complicated SQL Query, which runs on several Tables with Joins and Filters. I want to know how to use this SQL Query in Excel and retrieve data into Spreadsheet. Following is what I am able to do right now: €¢I am able to connect to SQL Server and retrieve the data into Spreadsheet. €¢I am able to pull Data into Excel sheet using simple MS Query. I want to know, how to use this SQL Query and retrieve the Data from SQL Server into a Spreadsheet. Also, if possible, can you please give me any good Website location, where I can get more knowledge about MS Query. Thank you in Advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query SQL Server from Excel | Excel Discussion (Misc queries) | |||
Query SQL Server from Excel | Excel Worksheet Functions | |||
Excel not finding the server in web query | Excel Discussion (Misc queries) | |||
How do I run a SQL query against a MS SQL Server database from exc | Excel Discussion (Misc queries) | |||
Use SQL statements in Excel VBA to query SQL Server Data Problem | Excel Worksheet Functions |