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
Export sales into general ledger spreadsheet (Read 3378 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Export sales into general ledger spreadsheet
21.06.07 at 11:38:32
 
Export sales into general ledger spreadsheet
 
Question:
My purpose of using the software is to export daily restaurant totals from a
sql database to specific cells in an excel spread sheet. With no direct
intervention from the operator.  
 
And to be able to do this thought a command line statement or batch file.
 
For instance:
 
Run batch 'sql*xl.bat'
Which would export restaurant food sales from the sql database to cell B3 in
the 'General ledger spreadsheet'.
 
Or at command prompt statement such as:
 
Sql*xl.exe -x -y -z -1
 
That would do the samething.
 
Answer:
You can write a batch file to do this but there is no executable statement. I have given the details for the batch file below. However there may be an easier way to do this.
 
Why not use a formula that automatically attaches your restaurant food sales from the database to your Excel cells in the general ledger spreadsheet. You can use the SQLQueryValue function to do this.  
 
Over the past few months I have added some information about what I call dashboards or cockpits. Some call them BI dashboards as well. Perhaps it gives you some ideas on how to do this. When using the SQLQueryValue function you only need to establish the connection in the way you are already used to do and you need to refresh the formulas which you can do using the SQL*XL menu SQL*XL, insert functions, calculate, calculate all
 
Further reading:
LIT Software Forums - Tutorial: creating dashboards
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1172472828
SQL*XL: SQLQueryValue Excel function
http://www.oraxcel.com/projects/sqlxl/help/functions/sqlqueryvalue.html
SQL*XL: Automate the daily insertion of a dbase file into Oracle ...
http://www.oraxcel.com/projects/sqlxl/help/techniques/dbfimport.htm
Back to top
 
« Last Edit: 21.06.07 at 11:46:59 by Gerrit-Jan Linker »  

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