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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO connection to Excel 2007 *.xlsx files? 8
Excel problem reading data when aflanumreic field is numeric 0
Extracting Data Without Opening Workbooks 2
Excel 2003 ODBC driver without support for XML files? 0
Importing .xlsm, .xlsx with OLEDB 5
importing file into a new file 2
Sql probleme on emty cell 1
ADODB Testing for Password 2

Top