topic Help with OLEDB in QlikView

Help with OLEDB

Thu, 15 Jul 2010 12:44:51 GMT

Hello,
I try to run scripts with this line:
CONNECT TO [Provider = Microsoft.Jet.OLEDB.4.0; Data Source = $ (DictionaryFile); Extended Properties = "Excel 8.0;"];

I checked the file path and is correct.
The problem is, apparently, with the OLEDB.
I'd happy to hear from your experience.
Is using OLEDB requires installation?
What is Microsoft.Jet?

Thank you
Elad

Help with OLEDB

Thu, 15 Jul 2010 12:49:53 GMT

Why are you using OLEDB to open an Excel File ?

Also what is the error you have exactly ?

Rgds,

Help with OLEDB

Thu, 15 Jul 2010 13:18:26 GMT

Hello,

Thank you for you're your answer,

I try to implement the "QVD Monitor Files" Model and there I need to read multiple sheets from XLS file.

This is the error messages:

OLEDB connection failed
tables:
?SQLtables

And next error is::

Script line error:
For i = 0 to No OFRows('tables')-1

And next error is:

Script line error:
Next

And in the end:

Table not found
DROP TABLES statement

Help with OLEDB

Tue, 20 Jul 2010 12:35:16 GMT

Hello,

We try to install Install "Microsoft.Jet.OLEDB.4.0" on "Microsoft Windows Server 2003 R2, Enterprise X64 Edition' Service Pack 2"

Without success.

Any Idea?

Elad