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
Map cells to the database table (Read 2476 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Map cells to the database table
08.03.06 at 14:52:00
SQL*XL user Richard asked the following question:
We have existing spreadsheets that pre-defined formatting and layout.  Ideally, I would like to integrate SQL*XL with the existing spreadsheets and define specific cells to map to the target database table.  Is this possible?
Yes you can. In fact this has been dealt with in the following forum topics:

To summarise:
You enter the following formula in the cell that you want to map to your database value:
=sqlxl.xla!SQLQueryValue( "select count(*) from mytable" )
Now, you probably require some other cell values to be used in the SQL select statement. The easiest is if you use the Excel concatenate function to build your SQL in the cell. Example:
=sqlxl.xla!SQLQueryValue( concatenate("select count(*) from mytable where col1 = ", A1)
Back to top
« Last Edit: 08.03.06 at 14:58:22 by Gerrit-Jan Linker »  

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