not processed string in sst[20]

解决导入Excel XLS文件时遇到的'无效指针错误'或'SST[20]未处理字符串'

最新推荐文章于 2024-10-25 17:53:02 发布

原创最新推荐文章于 2024-10-25 17:53:02 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

17 篇文章

订阅专栏

当使用Toad的数据导入向导导入由第三方程序生成的Excel XLS文件时，可能会遇到'无效指针错误'或'SST[20]未处理字符串'的问题。本文提供了两个解决方案：一是打开Excel文件并确保解冻所有窗格；二是创建一个新的空白XLS文件，并将原始内容复制粘贴到新文件中，然后使用Toad的数据导入功能进行导入。

Title

Import Excel XLS file gives "invalid pointer error" or "not processed string in SST [20]"
Description

Error received when importing an Excel file using the Data Importer Wizard by selecting Database | Import | Table Data:

"invalid pointer error"
or
"not processed string in SST [20]".
Cause

Excel sheet generated by 3rd party program is not compatible with Toad's Import Wizard.
Resolution

RESOLUTION 1:

1) Open the XLS file in Excel.

2) Make sure to unfreeze the panes by going to "Windows | Unfreeze pane" in the Excel menu.

3) Check for hidden rows and drag out any rows that are hidden in the spreadsheet.

RESOLUTION 2:

1. Open Microsoft Excel and create A new blank XLS file.

2. Copy the entire contents of the original XLS and paste into new XLS file.

3. Import the new XLS file using Toad's Data Importer.