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.