从源Excel文件读取字母数字值时出现问题 [英] Issue while reading alphanumeric values from source excel file

问题描述

我正在从excel文件中读取数据，它的一列中包含字母数字值. Alpha数字列的前200行为数字，其余行为文本.从excel文件中读取数据时，数值会正确显示，但文本值会显示为NULL.我已将列类型更改为文本，并在连接字符串设置中也使用了IMEX = 1标志，但仍无法正常工作.有人可以为我提供解决方案.

I am reading data from excel file, one of its column is having alphanumeric value in it. Alpha numeric column has first 200 rows as numeric and rest of the rows are text. While reading the data from excel file, numeric values are coming properly but the text values are appering as NULL. I have changed the column type as text and have used the IMEX = 1 flag as well in the Connection string setting but still its not working. Can somebody provide me the solution.

推荐答案

请在数字开头之前添加''"符号.

示例:

假设我们有号码1234
只需将''符号连接到1234
结果将是''1234

实际1234
更改为''1234

更改数字单元格，然后尝试.它将起作用.

Please add "''" symbol before the number starts.

Example:

suppose we have number 1234
just concatenate '' symbol to 1234
The result will be ''1234

Actual 1234
Changed ''1234

change the numeric cell and then try. it will work.

这篇关于从源Excel文件读取字母数字值时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！