<div>
I have downloaded the provider and tried to install it but it won't install as 32bit office is already installed on this machine. &nbsp;I have uninstalled the 32 bit office but now I have to reboot the server before the 64bit provider will install. &nbsp;This will probably be overnight as this server is in constant use.
</div>


I have downloaded the provider and tried to install it but it won't install as 32bit office is already installed on this machine.  I have uninstalled the 32 bit office but now I have to reboot the server before the 64bit provider will install.  This will probably be overnight as this server is in constant use.

<div>
Apologies for delay but this project got put on the back burner and I have been unable to fully test this solution. As far as I can tell it does what I wanted it to do.
</div>


Apologies for delay but this project got put on the back burner and I have been unable to fully test this solution. As far as I can tell it does what I wanted it to do.

<div>
<div class="content wysiwyg-content">
I want to export from SQL server to an Excel Spreadsheet. &nbsp;I tried<br />
insert into OPENROWSET('Microsoft.Jet.<wbr />OLEDB.4.0'<wbr />, <br />
&nbsp; &nbsp; 'Excel 8.0;Database=D:\testing.xl<wbr />s;', <br />
&nbsp; &nbsp; 'SELECT * FROM [SheetName$]') select * from table<br />
But I got error 'The OLE DB provider &quot;Microsoft.Jet.OLEDB.4.0&quot; has not been registered.'<br />
This seems to be a common problem with 64 bit SQL server and there is a lot of confusing information available on the web, so can anyone who has done this tell me how to export to excel from 64 bit SQL server 2008. &nbsp;I am working on a SMall Business Server 2008.<br />
Does Excel have to be installed on the server to aloow exporting to excel?
</div>
</div>


I want to export from SQL server to an Excel Spreadsheet.  I tried
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
    'Excel 8.0;Database=D:\testing.xls;', 
    'SELECT * FROM [SheetName$]') select * from table
But I got error 'The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.'
This seems to be a common problem with 64 bit SQL server and there is a lot of confusing information available on the web, so can anyone who has done this tell me how to export to excel from 64 bit SQL server 2008.  I am working on a SMall Business Server 2008.
Does Excel have to be installed on the server to aloow exporting to excel?

Export to Excel from 64 bit SQL Server 2008

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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.