TXT怎么导入到SQL2000啊还有,怎么判断最后一位是0的时候不导入啊???
第一行不管他。003|104|6255.40
35190087557400002820|林玉华|82.80|1260000066|林玉华|1
6222600720003461622 |何惠琼|41.40|1260000052|何惠琼|1
35190086837200001520|唐良斌|179.40|1260000053|唐良斌|0
第一行不管他。003|104|6255.40
35190087557400002820|林玉华|82.80|1260000066|林玉华|1
6222600720003461622 |何惠琼|41.40|1260000052|何惠琼|1
35190086837200001520|唐良斌|179.40|1260000053|唐良斌|0
FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.1.1.2; UserID=sa; Password=qwert1').pubs.dbo.authors02. 导出数据INSERT INTO OPENDATASOURCE('SQLOLEDB', 'Data Source=192.1.1.2; UserID=sa; Password=qwert1').test.dbo.authors
SELECT * FROM pubs.dbo.authorsINSERT INTO OPENDATASOURCE('MICROSOFT.JET.OLEDB.4.0','Text;DATABASE=c:\')[data#txt] SELECT * FROM text1INSERT INTO OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;DATABASE=c:\', [data#txt]) SELECT * FROM text103. 导入Excel数据SELECT * INTO excel FROM OPENDATASOURCE('MICROSOFT.JET.OLEDB.4.0', 'Excel 5.0;DATABASE=c:\book1.xls' )[Sheet1$]04. 导入到ExcelINSERT INTO OPENDATASOURCE('MICROSOFT.JET.OLEDB.4.0', 'Excel 5.0;DATABASE=c:\book1.xls' )[Sheet1$] SELECT * FROM excel本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/htl258/archive/2009/04/14/4070668.aspx
from 'd:\kq\kq.txt'--文件路径'd:\kq\kq.txt'
with
(FIELDTERMINATOR = '',--字段间分隔符号
ROWTERMINATOR = '\n'--每条记录分隔符
)
至于为0项,我觉得可以导入后,设置属性:不能为0。
from 'txt文件的路径'
with
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)
select * from 数据库的名字
35190087557400002820|林玉华|82.80|1260000066|林玉华|1 我选择几个来导入啊
35190087557400002820|林玉华|82.80|1260000066 这样可以吗
003|104|6255.40
35190087557400002820|林玉华|82.80|1260000066|林玉华|1
6222600720003461622 |何惠琼|41.40|1260000052|何惠琼|1
35190086837200001520|唐良斌|179.40|1260000053|唐良斌|0
我把语句改成
EXEC master..xp_cmdshell 'bcp jd_Gas.dbo.TMP in C:\2009\20090707.txt -F"1" -c -U"sa" -P"sa" -t"|"'
数据就变成第一行的跟第二行的数据连在一起了,这个要怎么改啊???003|104|6255.40 35190087557400002820|林玉华|82.80|1260000066|林玉华|1
6222600720003461622 |何惠琼|41.40|1260000052|何惠琼|1
35190086837200001520|唐良斌|179.40|1260000053|唐良斌|0