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