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?

Thanks in advance