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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel with SQL Query (*.sql) and SQL Server
hi,
Posting your code would have been nice. try this side.... http://office.microsoft.com/en-us/ex...747511033.aspx but it has been my experience with MSQ that MSQ is really not safisticated enough to handle complaicate joins. I found better luck linking the tables to access, writing the query in access then using MSQ to pull the access query into excel. Regards FSt` "Kode" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel with SQL Query (*.sql) and SQL Server
Thank you for your Post FST.
But still this doesn't explain me how to use a Excel & already existing SQL Query to pull the Data into Excel sheet. Thanks for the Input though. Thank you Very Much, Kode. "FSt1" wrote: hi, Posting your code would have been nice. try this side.... http://office.microsoft.com/en-us/ex...747511033.aspx but it has been my experience with MSQ that MSQ is really not safisticated enough to handle complaicate joins. I found better luck linking the tables to access, writing the query in access then using MSQ to pull the access query into excel. Regards FSt` "Kode" wrote: 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. |
Reply |
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 |