1、
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]')
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]')
1、
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]')
--------------------------------------------------------------------------
大力是不是问题大多了?条件反射,呵呵我可没看到这里楼主问问题啊!