CODEWITHSUNDEEP
exceloledbconnection
Mauro Destro
Mauro Destro

Reputation: 766

OleDbConnection failed creating a new excel file

I have to use OleDbConnection to create a new excel file, but when I open connection with this string:

OleDbConnection excelConnection =
                new OleDbConnection(
                    String.Format(
                        @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Mode=ReadWrite;Extended Properties=""Excel 12.0;HDR=YES"";",
                        excelFile));

I receive an error that in english sounds like "The outer table is not in the expected format."

But the file is NEW and empty ... how can i do?

Upvotes: 2

Views: 986

Answers (1)

Mauro Destro
Mauro Destro

Reputation: 766

I have changed to ExcelPackage library, and now it works.

Upvotes: 2

Related Questions