Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Aug 14, 2013 7:43 am**

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

Posted: **Wed Aug 14, 2013 10:19 am**

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.

Posted: **Wed Aug 14, 2013 10:43 am**

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

Posted: **Wed Aug 14, 2013 11:45 am**

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.

Creating reports and dashboards | Stimulsoft community forum

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

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

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

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

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