Excel with SQL Query (*.sql) and SQL Server

[Guest]

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.

 

[Guest]

hi,
Posting your code would have been nice.
try this side....
http://office.microsoft.com/en-us/excel/HP052747511033.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`

 

[Guest]

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.