How to determine xls file's codepage/collation

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
 
Top