<div>
<a href="http://blogs.msdn.com/b/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx" rel="ugc">http://blogs.msdn.com/b/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx</a>
</div>


<div>
Try to check &quot;Non transacted updates&quot; option in &quot;Server objects - Linked servers - Providers - Microsoft.Jet.OLEDB.4.0&quot; properties.
</div>


<div>
You needed to install the Data Connectivity Components on the server too! &nbsp;Here is the link where you can download and install the file on your sever which will fix the problem.<br />
<br />
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=23734" rel="ugc">http://www.microsoft.com/en-us/download/details.aspx?id=23734</a>
</div>


<div>
<a href="http://blog.hoegaerden.be/2010/03/29/retrieving-data-from-excel/" rel="ugc">http://blog.hoegaerden.be/2010/03/29/retrieving-data-from-excel/</a>
</div>


<div>
You should know that there is no 64-bit JET driver.
</div>


<div>
In my SQL Server 2012 server, I searched for my ODBC drivers and found the following (see image):<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/07_w28/665808/ODBCDrivers.JPG" target="_blank" title="ODBC Drivers on my Windows 2008 R2 server machine (34 KB)"><img alt="ODBC Drivers on my Windows 2008 R2 server machine" class="file-block lazyload" style="max-width: 517px;" data-src="https://filedb.experts-exchange.com/incoming/2013/07_w28/665808/ODBCDrivers.JPG" /></a><br />
<br />
Is this correct? &nbsp;Thanks in advance,<br />
mrotor
</div>


ODBC Drivers on my Windows 2008 R2 server machine

ODBCDrivers.JPG

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I get the following error when I try exporting data from a Stored Proc into Excel from SQL Server 2012.<br />
<br />
Cannot create an instance of OLE DB provider &quot;Microsoft.Jet.OLEDB.4.0&quot; for linked server &quot;(null)&quot;.<br />
<br />
Any idea how to fix this, will be greatly appreciated.<br />
<br />
Thanks in advance,<br />
mrotor
</div>
</div>


Hi Experts,
I get the following error when I try exporting data from a Stored Proc into Excel from SQL Server 2012.

Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Any idea how to fix this, will be greatly appreciated.

Thanks in advance,
mrotor

http://blogs.msdn.com/b/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx

Try to check &quot;Non transacted updates&quot; option in &quot;Server objects - Linked servers - Providers - Microsoft.Jet.OLEDB.4.0&quot; properties.

You needed to install the Data Connectivity Components on the server too!  Here is the link where you can download and install the file on your sever which will fix the problem.

http://www.microsoft.com/en-us/download/details.aspx?id=23734

http://blog.hoegaerden.be/2010/03/29/retrieving-data-from-excel/

You should know that there is no 64-bit JET driver.

In my SQL Server 2012 server, I searched for my ODBC drivers and found the following (see image):




Is this correct?  Thanks in advance,
mrotor

Need help exporting data from a stored proc to Excel

Hi Experts,
I get the following error when I try exporting data from a Stored Proc into Excel from SQL Server 2012.

Cannot create an instance of OLE DB provider &quot;Microsoft.Jet.OLEDB.4.0&quot; for linked server &quot;(null)&quot;.

Any idea how to fix this, will be greatly appreciated.

Thanks in advance,
mrotor

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.