not processed string in sst[20]

最新推荐文章于 2024-04-02 18:46:17 发布

xiuhaijuanqiang

最新推荐文章于 2024-04-02 18:46:17 发布

阅读量1k

点赞数

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/xiuhaijuanqiang/article/details/9178055

版权

数据库专栏收录该内容

17 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.