SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 OpenRowSet
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

goss
Starting Member

USA
24 Posts

Posted - 07/14/2014 :  23:04:37  Show Profile  Reply with Quote
Hi all,

Using SQL Server 2012 Developer Edition. I am trying to import an .xlsx worksheet using ACE12.0 Driver.

I believe I tried everything in this blog post from Visakh : http://visakhm.blogspot.com/2013/12/how-to-solve-microsoftaceoledb120-error.html

But I am still receiving this error message:

quote:

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".



What else can I try?

thx
w

Kind regards,
-w

khtan
In (Som, Ni, Yak)

Singapore
17681 Posts

Posted - 07/14/2014 :  23:24:51  Show Profile  Reply with Quote
do you have the driver installed on the same machine as your SQL Server ?

is the excel file located on the same machine ?


KH
Time is always against us

Go to Top of Page

goss
Starting Member

USA
24 Posts

Posted - 07/15/2014 :  21:59:34  Show Profile  Reply with Quote
Thanks khtan,

I see Microsoft.ACE.OLEDB.12.0 here in Management Studio:
Server Objects >> Linked Servers >> Providers >> ...ACE...

Everything is one machine

thx
w

Kind regards,
-w
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17681 Posts

Posted - 07/15/2014 :  22:36:41  Show Profile  Reply with Quote
can you show us the query ?

also what is the name of the worksheet you are trying to access ?


KH
Time is always against us

Go to Top of Page

goss
Starting Member

USA
24 Posts

Posted - 07/15/2014 :  22:41:04  Show Profile  Reply with Quote
The name of the worksheet is Sheet1


Use ExcelDB
Select * Into tblTest FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
									  'Excel 12.0;Database=C:\Data\NFL Teams.xlsx;HDR=Yes',
									  'SELECT * FROM [sheet1$]')


Kind regards,
-w
Go to Top of Page

goss
Starting Member

USA
24 Posts

Posted - 07/16/2014 :  21:50:52  Show Profile  Reply with Quote
Bump

Kind regards,
-w
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000