View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kode Kode is offline
external usenet poster
 
Posts: 4
Default 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.