C# : Error appearing when uploading excel 2003 instead of excel 2007

Hi,

I have one issue here where i need help to.
I'm writing in C# and i have a function where user will upload a static format excel file
and the system will upload it to db.

I'm using sample code as below:
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileName + "; Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1;\"";

Issue is, when i upload a excel 2007 SAVED file, everything is ok but when my user upload an excel 2003 SAVED file, then error will appear "Selected collating sequence not supported by operating system"

Can anyone help me on this.

tbh I'm surprised that

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileName + "; Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1;\"";

works at all for 2007 files since they are XML based an are essentially zip files. I would have thought that you need to use the ACE connector.

Your issue seems to be related to the language have a look here and here