bcp格式文件未知版本
有一个文本格式如下 数据之间以空格分开
2008010908 54517 -4.2 -1.2 0.7 -3.7 -6.7 -8.1 -9.2 -10.2 -10.8 -3.7 -1.1 -3.5 -6.7 -6.7 -5.9 -5.6 -6.2
2008010908 A3501 -4.3 -1.3 0.6 -3.7 -6.7 -8.2 -9.3 -10.3 -10.8 -3.7 -1.1 -3.6 -6.8 -7.3 -6.2 -5.9 -6.7
2008010908 A3502 -4.3 -1.3 0.6 -3.8 -6.7 -8.2 -9.3 -10.3 -10.9 -3.7 -1.1 -3.6 -6.9 -7.3 -6.2 -5.9 -6.7
2008010908 A3503 -4.4 -1.4 0.6 -3.8 -6.8 -8.2 -9.3 -10.3 -10.9 -3.7 -1.1 -3.7 -6.9 -7.2 -6.2 -5.8 -6.7
2008010908 A3504 -4.4 -1.4 0.6 -3.8 -6.8 -8.2 -9.4 -10.4 -10.9 -3.8 -1.1 -3.7 -6.9 -7.9 -6.5 -6.3 -7.3
2008010908 A3505 -4.3 -1.3 0.6 -3.7 -6.7 -8.2 -9.3 -10.3 -10.8 -3.7 -1.1 -3.6 -6.8 -7.3 -6.2 -5.9 -6.7
2008010908 A3506 -4.3 -1.3 0.6 -3.8 -6.7 -8.2 -9.3 -10.3 -10.9 -3.7 -1.1 -3.6 -6.9 -7.3 -6.2 -5.9 -6.7
2008010908 A3507 -4.5 -1.5 0.5 -3.8 -6.8 -8.3 -9.4 -10.4 -11 -3.8 -1.2 -3.8 -7 -7.7 -6.5 -6.3 -7.3
我写了段格式文件如下
8.0
19
1 sqlchar 0 10 " " 1 datatime sql_latin1_general_cp437_as
2 sqlchar 0 5 " " 2 station_id sql_latin1_general_cp437_as
3 sqlchar 0 8 " " 3 A08 sql_latin1_general_cp437_as
4 sqlchar 0 8 " " 4 A11 sql_latin1_general_cp437_as
5 sqlchar 0 8 " " 5 A14 sql_latin1_general_cp437_as
6 sqlchar 0 8 " " 6 A17 sql_latin1_general_cp437_as
7 sqlchar 0 8 " " 7 A20 sql_latin1_general_cp437_as
8 sqlchar 0 8 " " 8 A23 sql_latin1_general_cp437_as
9 sqlchar 0 8 " " 9 B02 sql_latin1_general_cp437_as
10 sqlchar 0 8 " " 10 B05 sql_latin1_general_cp437_as
11 sqlchar 0 8 " " 11 B08 sql_latin1_general_cp437_as
12 sqlchar 0 8 " " 12 B11 sql_latin1_general_cp437_as
13 sqlchar 0 8 " " 13 B14 sql_latin1_general_cp437_as
14 sqlchar 0 8 " " 14 B17 sql_latin1_general_cp437_as
15 sqlchar 0 8 " " 15 B20 sql_latin1_general_cp437_as
16 sqlchar 0 8 " " 16 B23 sql_latin1_general_cp437_as
17 sqlchar 0 8 " " 17 C02 sql_latin1_general_cp437_as
18 sqlchar 0 8 " " 18 C05 sql_latin1_general_cp437_as
19 sqlchar 0 8 " " 19 C08 sql_latin1_general_cp437_as
<a href="http://picasaweb.google.com/stin.wang/EcOuqF/photo#5178916515479210034"><img src="http://lh3.google.com/stin.wang/R981IbqKyDI/AAAAAAAAAUo/t13h0sxGAN0/s144/2.JPG" /></a>