Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Put results in different sheets (Read 3720 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Put results in different sheets
16.03.06 at 13:54:32
Martin from The Netherlands asked the following question.
I know you can run multiple select queries in Excel with SQL*XL. The results are received underneath of eachother.  
I would like to dump the result of each query in its own sheet.
Yes you can. SQL*XL cannot create the sheets for you so ensure you have created the sheets before you run the queries. You can use the select to syntax of SQL*XL to achieve what you want.
Suppose you want to run three queries and dump the results into sheet1 to sheet3. You would run:

select * from table1 to sheet1!A1;
select * from table2 to sheet2!A1;
select * from table3 to sheet3!A1;

Back to top
« Last Edit: 30.03.06 at 09:43:58 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1