Unanswered: Excel: Selected collating sequence not supported by operating system
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"