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
kubilay bayraktar
NA
40
0
c# xls and xlsx file import
Sep 7 2012 3:12 AM
Hi,
I want to load xls and xlsx file in c#.
For xls I'm using:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<filename>;Extended Properties=\"Excel 8.0;HDR=YES\
For xlsx :
Provider=Microsoft.Ace.OLEDB.12.0;Data Source=<filename>;Extended Properties=\"Excel 12.0;HDR=YES\
once the projects platform target was Any Cpu
I can upload xlsx file without problem but when I upload xls file I got the following error:
"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."
And if I change the Platform Target to x86 then xls file is uploaded without problem but
this time xlsx file is giving this error:
"The 'Microsoft.Ace.OLEDB.12.0' provider is not registered on the local machine."
How can I upload but file formats without error?
Thanks
Reply
Answers (
3
)
The child/descendant class object references can not point to the parent/ancestor class objects. Why and how ????
Create a win service which call an exe and open a pop up