c# xls and xlsx file import

kubilay bayraktar

Sep 7 2012 3:12 AM

4.8k

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