下面一个.TXT文本文件（BOM表） 求导入SQLSEERVER 的方法
LEVEL PART IDENTIFIER DESCRIPTION EFF DATE QTY/ASSY UOM ECN REFERENCE
----- --------------- ------------------------- -------- ---------- --- ---------- -----------------------
0 CM12F(A)=104 PC INTERFACE FRANCE 08960 20060210 1.0000 EA
1 033000=11028A CD SLEEVE (MARMITEK) 20060210 1.0000 EA
1 033000=12038C MINI CATALOG 20060210 1.0000 EA
1 033000=12085 INNER TRAY 20060210 1.0000 EA
1 038010=13207C GIFT BOX LABEL CM11F 20060210 1.0300 EA
1 040010=10912E GIFT BOX (L) 20060210 1.0300 EA
1 040040=10469 1-P CORR.PAPER (35X29)CM 20060210 0.0500 EA
1 040040=10643 2P CORR. PAPER (38X28.5) 20060210 0.1000 EA
1 045030=10870 2P SHPG CTN 40X30.5X39 20060210 0.0500 EA
1 098=15081000 BATTERY-1.5V AAA 20060210 2.0000 EA
1 189002=10003 BUBBLE BAG 20060210 1.0000 EA
1 189010=10046 POLYBAG 38"X38" 20060210 0.0500 EA
1 189010=10069 POLYBAG 4.75"X7.75" 20060210 1.0000 EA
1 314000=10019C CD-ROM (MARMITEK)V1.42 20060210 1.0000 EA
1 851100=10027 INTERFACE CABLE 4P4C FLAT 20060210 1.0000 EA
1 CM12F(A)=104U PC INTERFACE FRANCE NPACK 20060210 1.0000 EA
.2 038010=10040-X LABEL-DATE CODE (WHITE) 20060210 2.0000 EA
.2 038020=12418A RATING LABEL (CM11) 20060210 1.0000 EA
.2 183010=10260A SHUTTLE (WHITE) 20060210 1.0000 EA
.2 183010=12640 SOCKET-TOP (WHITE) 20060210 1.0000 EA
.2 183010=12650 SHUTTLE COVER (WHITE) 20060210 1.0000 EA
.2 183010=15020 BATTERY DOOR (WHITE) 20060210 1.0000 EA
.2 183010=20356 SOCKET-BOTTOM WHITE 20060210 1.0000 EA
.2 185000=14203 TOP CABINET (MARTEK) 20060210 1.0000 EA
.2 185000=14210B BOTTOM CABINET 20060210 1.0000 EA
.2 201=15080000 TUBE-HS 1.5MM BLACK 20060210 0.2000 M
.2 354=11600019 WIRE UL1015 #16 WHITE 20060210 0.0600 M W8
.2 354=12200010 WIRE UL1015 #22 BLACK 20060210 0.1800 M W2
.2 354=12200012 WIRE UL1015 #22 RED 20060210 0.1600 M W1
.2 354=12600000 WIRE UL1007 #26 BLACK 20060210 0.1100 M
问题点数：30、回复次数：3Top
1 楼ashzs（(可以包含中文字符)）回复于 2006-02-22 22:22:06 得分 5
用SQL Server的bcp或者dtsTop
2 楼samfeng_2003（凤翼天翔）回复于 2006-02-22 22:52:34 得分 15
第一，可以通过企业管理器的数据导入服务，但是前提是去掉行的特别鉴别符号，如----
然后在每列加上比较显著的分隔号，比如我把数据改了一下，取了部分数据建立的表
LEVEL,PART,IDENTIFIER,DESCRIPTION
0,CM12F(A)=104,PC INTERFACE FRANCE 08960 20060210,1.0000
1,033000=11028A,CD SLEEVE (MARMITEK) 20060210,1.0000
1,033000=12038C,MINI CATALOG20060210,1.0000
use fx
select * from fx
LEVEL PART IDENTIFIER DESCRIPTION
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0 CM12F(A)=104 PC INTERFACE FRANCE 08960 20060210 1.0000
1 033000=11028A CD SLEEVE (MARMITEK) 20060210 1.0000
1 033000=12038C MINI CATALOG20060210 1.0000
（所影响的行数为 3 行）
Top
3 楼QQMagicer（在IT的路上越走越远）回复于 2006-02-23 13:07:06 得分 10
用sqlserver的DTS，直接数据库名-〉右键-〉所有任务-〉导入数据-〉选择源数据为txt文件，目的数据库为sqlserver2000-〉然后选择要导入的数据表，执行就可以了,具体看提示Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
