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
SQL*XL Formulas in Excel 2010 (Read 5181 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL*XL Formulas in Excel 2010
31.01.11 at 22:06:41
 
SQL*XL Formulas in Excel 2010
 
Quote:

after changing to Excel 2010 on Win 7, there raise some errors in using
SQL*XL.
Up to now, we use Office 2003 on XP which worked fine.

Some differences I found and was able to fix them.
This still remains:
If an SQL-Statement is written in a Cell, sometimes Excel shows the
absolute path to "sqlxl.xla". This path is not the same on all machines,
specialy not when using Windows 7 with Office 2010).

Good statement:
=SQLQueryValueVolatile(SELECT)

Bad statement:
='C:\Program Files\SQLXL\sqlxl.xla'!SQLQueryValueVolatile(SELECT)

"(SELECT)" references to a named cell, making it easyer to support...

Is there a way to fix this?
How can Excel find the path automatically?

 
Perhaps the rules whether or not to store the path are related to Excel 2010. I found this article athat outlines how Excel works:
http://support.microsoft.com/kb/328440
 
I hope this helps.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: SQL*XL Formulas in Excel 2010
Reply #1 - 02.02.11 at 21:22:02
 
Quote:
Unfortunately this is only a good information but doesn't help solving
our troubles.
As described in this article, there seems to be no possibility to
influence the path, excel uses in those links.

 
Excel 'sees' sqlxl.xla in different locations and it decides to store the full path for it. You can remove the full path again. It is easiest done by doing a search and replace.
 
To prevent this from happening you can indeed use a common path to it. It may help to reregister the file litsqlxl.dll using the specific path you want SQL*XL to use. You must do this from the location you wish it to be registered with. E.g. regsvr32 c:\programme\litsqlxl.dll.
 
Quote:
Thanks for your last hint, I've got it working now.
Back to top
 
 

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