Home » Categories » CHARTrunner

CR: Collating sequence not supported

Revision Date: 2005-09-19

Problem:

When charting Excel data that may have originated by exporting from a Paradox database, the following error is displayed:

Selected collating sequence not supported by the operating system

Solution:

This may occur when the Excel sheet contains a date column. If you open the Excel sheet (in Excel) and then save it to disk, this error will usually be corrected. There is something about the way in which Paradox exports date columns to Excel that the database engine does not like. Once Excel has saved the sheet on its own this problem is usually fixed.

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: SQL Server Stored Procedures Returns No Records
Viewed 2268 times since Fri, Nov 9, 2007
CR: Making a chart transportable
Viewed 2115 times since Fri, Nov 9, 2007
CR: Excel tips
Viewed 3019 times since Tue, Oct 6, 2009
CR: A simple query pattern for summarizing raw data
Viewed 2914 times since Tue, Oct 6, 2009
CR: A custom query for Length of Stay data
Viewed 2511 times since Fri, Nov 9, 2007
CR: Label your X-Axis with more than one identifier
Viewed 2521 times since Tue, Oct 6, 2009
CR: Time Display
Viewed 2075 times since Fri, Nov 9, 2007
CR: Changing the chart type will change the Default Chart Style to missing
Viewed 2105 times since Fri, Nov 9, 2007
CR: Charts with large amounts of data
Viewed 1914 times since Fri, Nov 9, 2007
CR: General Filtering Tips
Viewed 2205 times since Fri, Nov 9, 2007