是字符,文本文档里以逗号隔开的字符,但这种字符的内容全是一个个阿拉伯数字,我想以字符型写进表里.文本文档如下:
=================================================================
9377771353743,9313938000532,165106,050516,1004,00,,HTP29135A
9377771353744,9313938000534,165106,050516,1004,00,,HTP29135A,
............
............
=================================================================
9377771353743,9313938000532,165106,050516,1004,00,,HTP29135A
9377771353744,9313938000534,165106,050516,1004,00,,HTP29135A,
............
............
那我的就有
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;DATABASE=C:\',hhhh#txt)
F1
---------------------------------
JKLYJ 35 0.870000004768372
asdad 34 01231313
JKLYJ 50 0.639999985694885
JKLYJ 70 0.439999997615814
JKLYJ 95 0.319999992847443
JKLYJ 120 0.25
JKLYJ 150 0.209999993443489
JKLYJ 185 0.159999996423721
JKLYJ 240 0.129999995231628
JLYJ 25 1.51999998092651
--------------------------------------------------------------
9377771353743,9313938000532,165106,050516,1004,00,,HTP29135A,0.16
9377771353744,9313938000534,165106,050516,1004,00,,HTP29135A,0.12
---------------------------------------------------------------
谢谢
你把字段之间的,去掉
9377771353743 9313938000532 165106 050516 1004 00 HTP29135A 0.16
9377771353744 9313938000534 165106 050516 1004 00 HTP29135A 0.12
---------------------------------------------------------------
"9377771353743,9313938000532,165106,050516,1004,00,,HTP29135A,0.16"
"9377771353744,9313938000534,165106,050516,1004,00,,HTP29135A,0.12"
---------------------------------------------------------------
--两边加个引号。