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. |
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. |
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. |
All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com