Unexpected error from external database driver (22)

Question

Here's my code which is in the beginning of a method for converting .xls file to .csv.

sourceFile="C:\\Users\\myUser\\Desktop\\Folder\\myFile.xls";

string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sourceFile + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\"";

OleDbConnection conn = new OleDbConnection(strConn);

conn.Open();

And it crashes on the last line, throwing this exception: Unexpected error from external database driver (22).

I tried removing the IMEX=1 part, but it still didn't work.

What is the problem?

@yogi It's an excell file with one sheet. The first row has two columns, and all the next have 9 columns. The cells have a background color. — petko_stankoski, Feb 07 '13 at 08:07

score 5 · Answer 1 · answered Aug 29 '13 at 18:08

5

I also had the same issue but I had to rename the spreadsheet to a shorter name, then it worked.(SQL 2012 Dev)

answered Aug 29 '13 at 18:08

user2730382

51
1
2

score 2 · Accepted Answer · answered Feb 14 '13 at 07:32

2

Strangely enough, I replaced the file in another folder and it worked. I have no idea why this is happening.

answered Feb 14 '13 at 07:32

petko_stankoski

10,459
41
127
231

1

Your application needs to be able to open the file with administrator permissions. You probably moved the file to a folder where your application had that level of access. – Ryan Kohn Jul 23 '14 at 13:59
I got this exception. And when I moved my excel file to a different folder, it worked. System.Data.OleDb.OleDbException. Unexpected error from external database driver 枰儛☐չ䔰疈 – Kiran R Dec 31 '15 at 16:22

score 1 · Answer 3 · answered Feb 07 '13 at 08:06

1

Try to use Microsoft.Jet.OLEDB.4.0 provider. Also I would advise you to use OleDbConnectionStringBuilder to build OleDbConnectionString:

var oleConnectionStringBuilder = new OleDbConnectionStringBuilder { Provider = "Microsoft.Jet.OLEDB.4.0" };
oleConnectionStringBuilder.DataSource = sourceFile;
oleConnectionStringBuilder.Add("Extended Properties", "Excel 8.0");
oleConnectionStringBuilder.Add("HDR", "No");

answered Feb 07 '13 at 08:06

Andrey Gordeev

30,606
13
135
162

With using your code I get Could not find installable ISAM. error. – petko_stankoski Feb 07 '13 at 08:11
@petko_stankoski Here is discussing about this error: http://stackoverflow.com/questions/4214527/could-not-find-installable-isam – Andrey Gordeev Feb 07 '13 at 08:15
@petko_stankoski, this thread contains possible solution too: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/62ee4978-ca29-48d3-9367-6dd4ab639d2d/ – Andrey Gordeev Feb 07 '13 at 08:16

score 0 · Answer 4 · answered Feb 07 '13 at 08:32

0

It seems that there is something wrong with the Microsoft Excel Driver. Try to execute the program in another PC to see whether this error happens.

Please take a look at this KB article:

http://www.codeproject.com/KB/database/ReadExcel07.aspx . You can use OleDb to connect the Excel file.

I hope this can help you and feel free to follow up after you have tried.

answered Feb 07 '13 at 08:32

Igoy

2,942
22
23

Which program do I need to execute on another pc? – petko_stankoski Feb 07 '13 at 08:33
Your application, and keep the file on that PC. – Igoy Feb 07 '13 at 08:35

score 0 · Answer 5 · answered Mar 16 '16 at 05:00

0

i have fixed this by uninstalling Microsoft access DB Engine Security update.Also Uninstall Service pack3 Update of access DB engine 2007. Hope this will work...

answered Mar 16 '16 at 05:00

AhmAd Luqman

1

score 0 · Answer 6 · answered Jul 20 '17 at 09:49

In my case I renamed excel file's sheet name(it was too long), after that it worked.

I'm using :

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties=\"Excel 12.0 Xml; IMEX=1;Importmixedtypes=text;\"";

Unexpected error from external database driver (22)

6 Answers6