How to makes connection to MS-Excel using Designer.EXE ?

[stvhui]

Hello to you,

I'm using Windows 7, 64 Bit, Installed Stimulsoft Report .NET 2013

When running designer.exe to design report
I choose for New Connection then OleDB Connection

The problem is The Data Link didn't shown Microsoft.Jet.4.0 Provider or Microsoft.ACE.12
I want to makes connection into Excel data file.

But If I using another PC installed Windows XP 32 Bit, also installed Stimulsoft Report .NET 2013, the Data Link can shown Microsoft.Jet.4.0 Provider or Microsoft.ACE.12

Please help, How?

Thanks in advance

Steven

[Alex K.]

Hello,

Please try to use the following connection string for OleDb Connection:

Code: Select all

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

or

Code: Select all

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

Thank you.

[stvhui]

Hi Aleksey,

If I forcing to write the connection string as you suggest
The error messages from Designer.EXE
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

Thanks & Regards,
Steven

[Alex K.]

Hello,

Please try to install the Jet. 4.0 from the following link:
http://www.microsoft.com/en-us/download ... x?id=21373

Also please see the following topik on our knowledgebase:
http://support.stimulsoft.com/index.php ... on-systems

Thank you.