How to determine xls file's codepage/collation

  • Thread starter Thread starter Jim R
  • Start date Start date
J

Jim R

Hi,

I'm getting "Selected collating sequence not supported by the
operating system" error when reading xls file using:

ConImp = New OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;
" & "data source=" & LoadLocation & "; " & "Extended Properties=Excel
8.0;")

The problem is I'm fairly sure the xls file and OS are both using
English language, so how can I make sure this is the case for the xls
file?

Thanks

Jim
 
Back
Top