Linker IT Software
Google
Web www.oraxcel.com
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
Summary of all queries (Read 5390 times)
hezi
YaBB Newbies
*




Posts: 3
Summary of all queries
26.10.05 at 13:35:13
 
I use a excel sheet with a bunge of SQL statements in different cells and work spaces. How can i get
a summary of all SQL statements from the sheet?
Back to top
 
 
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Summary of all queries
Reply #1 - 27.10.05 at 09:53:54
 
If you would use the Refresh Queries toolbar button SQL*XL will look for the SQL in the current workbook (.xls). SQL*XL will put all the SQL statements back into the SQL dialog. Is this what you mean?
 
See:
http://www.oraxcel.com/projects/sqlxl/help/menu%20items/refresh_queries.html
Back to top
 
 

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