How to determine xls file's codepage/collation   

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

date: Thu, 14 Aug 2008 08:11:22 -0700 (PDT)   author:   Jim R