Article ID: 246167 - View products that this article applies to.
This article was previously published under Q246167
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:
This problem occurs every time that you run the code within the Visual Basic IDE.
Run time error '-2147467259 (80004005)' : [Microsoft][ODBC Excel Driver]Selected collating sequence not supported by the operating system
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.
Steps to Reproduce Behavior
Article ID: 246167 - Last Review: June 24, 2004 - Revision: 3.1