c# xls and xlsx file import

kubilay bayraktar

Hi,

I want to load xls and xlsx file in c#.
For xls I'm using: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties=\"Excel 8.0;HDR=YES\
For xlsx : Provider=Microsoft.Ace.OLEDB.12.0;Data Source=;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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Constance Swinton12y ago
Hi, if interested here is a related discussion about this issue and why to use an AccessDatabaseEngine:
http://social.msdn.microsoft.com/Forums/vstudio/en-US/cfb9efe8-4de2-40b6-b817-553c91b9f9c6/the-microsoftjetoledb40-provider-is-not-registered-on-the-local-machine
Also an alternative which you could try is this .NET component for excel file manipulations.
Manipulations which you can achieve include the reading of excel files (both XLS and XLSX) with C# code in the same manner, like the following:
```
var xlsFile = ExcelFile.Load("Book1.xls");
```
var xlsxFile = ExcelFile.Load("Book1.xlsx");
12y ago
You can load(import) excel files in c# with Aspose.Cells for .NET Library.
Deepak Verma14y ago
Hi Kubilay,

You need to download AccessDatabaseEngine. Choose the appropriate download for you ...

Office 2007 : Download

Office 2010 : Download