Error while importing to excel
-
Hi,
I am trying to import sample data into excel,using following code,but it gives me following error,
Create Table Test
(
a Varchar(2),
b Varchar(2)
)
Insert Into test
values ('ab','bc')
insert into
openrowset('microsoft.ace.oledb.12.0',
'excel 12.0; database= D:\test' ,
'SELECT * FROM [Sheet1$]'
)select * from test
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "microsoft.ace.oledb.12.0" for linked server "(null)" reported an error. The provider did not give any information about the 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)".
-
avdhut.k (8/16/2013)
Hi,I am trying to import sample data into excel,using following code,but it gives me following error,
Create Table Test
(
a Varchar(2),
b Varchar(2)
)
Insert Into test
values ('ab','bc')
insert into
openrowset('microsoft.ace.oledb.12.0',
'excel 12.0; database= D:\test' ,
'SELECT * FROM [Sheet1$]'
)select * from test
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "microsoft.ace.oledb.12.0" for linked server "(null)" reported an error. The provider did not give any information about the 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)".
You need to specify an excel file.
You currently only have
database= D:\test
-
This is a duplicate post
http://www.sqlservercentral.com/Forums/Topic1485438-391-1.aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply