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

Posts: 75
One click batch execute
19.08.13 at 15:56:20
One click batch execute
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;
Back to top

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