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
SQLXL class information (Read 3626 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
SQLXL class information
29.01.12 at 14:40:34
SQLXL class information
We are evaluating SQL*XL and had much trouble in getting information on the SQLXL class - the web seems to only offer the basic elements. We are for the most part using it within excel's vb. For example what are some of the properties that we can set in SQLXL.UpdateSingle? Let us know if there is a better source of help/documentation or does that come with a paid license?

Thank you for your interest in SQL*XL.
It is true that if you look in Excel's VB editor that not all the SQL*XL syntax is visible. However we have documented it online:
Actually the best way to explore the syntax is to record the actions you wish to code in a macro. Observe the syntax and modify the code/or copy and paste.
With the paid license there will be an off-line help file which is a copy of what is available online.
Back to top

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