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
One click batch execute (Read 1240 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
One click batch execute
19.08.13 at 15:56:20
 
One click batch execute
 
Quote:
I have Multiple sheets in a xls, each sheet has a SQL statement in A1 cell.
Can I Batch execution all the SQL statment into Excel just with "one click"?

 
Yes you can run sql statements in a batch. But it is a little difficult the way you organised it.  
The easiest would be to make one script of sql statements where you end each statement with a semi colon. You can use the 'to clause' to be explicit where to put the results. It could look like this:
 
select * from table1 to sheet1!A1;
select * from table2 to sheet2!A1;
etc...
Back to top
 
 

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