c:\test.csv
aa,bb
422315633322111,aa
121215121212111,cc
121154541512121,tt
111225563356663,dd用:
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\;','SELECT * FROM [test#txt]')
aa,bb
422315633322111,aa
121215121212111,cc
121154541512121,tt
111225563356663,dd用:
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\;','SELECT * FROM [test#txt]')
sdf dsa s
asd akk ksd a
sss sss s
als aaa aaa a
aaa aaa aaa a
sld l四个字段,某些字段有时有字符有时没有,某些列后面空一格,某些列后面空三格。怎么办?严重感谢。