[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 636
  • Last Modified:

Export to Excel from 64 bit SQL Server 2008

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?
0
DCMBS
Asked:
DCMBS
  • 2
1 Solution
 
JestersGrindCommented:
Excel doesn't have to be installed, but the correct 64 bit provider does.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255

Your query is going to change slightly too.

insert into OPENROWSET('Microsoft.ACE.OLEDB.12.0',
    'Excel 14.0;Database=D:\testing.xls;',
    'SELECT * FROM [SheetName$]') select * from table

Greg

0
 
DCMBSAuthor Commented:
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.
0
 
DCMBSAuthor Commented:
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.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now