TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
jayakrishnan Morayur
NA
193
258.2k
Microsoft.ACE.OLEDB.12.0" for linked server "(null) error
Aug 26 2011 7:29 AM
INSERT INTO CSVTest select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=D:\b.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')
The following error occur on above line
Msg 7399, Level 16, State 1, Line 4
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 4
Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
Reply
Answers (
0
)
Import excel to sql error
How to write storedprocedure for search?