Opening an Microsoft Excel spreadsheet from within Visual Basic in Visual Studio 6.0 Service Pack 3 (or later) Integrated Development Environment (IDE) with the Excel/ODBC/ISAM driver generates the following run-time error:
Run time error '-2147467259 (80004005)' :
[Microsoft][ODBC Excel Driver]Selected collating sequence not supported by the operating system
This problem occurs every time that you run the code within the Visual Basic IDE.NOTE
This error does not occur if the all the fields are selected in the SQL statement, for example:
Also, this problem does not occur within a compiled EXE.
This is a problem within the Visual Basic IDE starting with service pack 3.