Help with OLEDB

[#1]

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

[#2]

Why are you using OLEDB to open an Excel File ?

Also what is the error you have exactly ?

Rgds,

[#3]

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

[#4]

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