G********7
发帖数: 234 | 1 field: fips_cnty
sample value: 13, 111,584,958
length: 3
create table的时候设这个field为[fips_cnty] char(3), 然后blulk insert 出错
Bulk load data conversion error (type mismatch..."
13正确的格式我想是“013" | g***l
发帖数: 18555 | | i****a
发帖数: 36252 | 3 Have you tried creating the table as varchar?
[发表自未名空间手机版 - m.mitbbs.com]
【在 G********7 的大作中提到】
: field: fips_cnty
: sample value: 13, 111,584,958
: length: 3
: create table的时候设这个field为[fips_cnty] char(3), 然后blulk insert 出错
: Bulk load data conversion error (type mismatch..."
: 13正确的格式我想是“013"
| G********7
发帖数: 234 | 4 改成varchar后，原来的error message没了，可是有来了如下error:
Bulk load: DataFileType was incorrectly specified as char. DataFileType will
be assumed to be widechar because the data file has a Unicode signature.
Bulk load: DataFileType was incorrectly specified as char. DataFileType will
be assumed to be widechar because the data file has a Unicode signature.
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The
provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
我是刚开始学sql的小菜鸟...
【在 i****a 的大作中提到】
: Have you tried creating the table as varchar?
:
: [发表自未名空间手机版 - m.mitbbs.com]
| i****a
发帖数: 36252 | 5 are you using bulk insert SQL command? try using a format file.
or use import/export wizard (or SSIS)
will
will
The
【在 G********7 的大作中提到】
: 改成varchar后，原来的error message没了，可是有来了如下error:
: Bulk load: DataFileType was incorrectly specified as char. DataFileType will
: be assumed to be widechar because the data file has a Unicode signature.
: Bulk load: DataFileType was incorrectly specified as char. DataFileType will
: be assumed to be widechar because the data file has a Unicode signature.
: Msg 4832, Level 16, State 1, Line 1
: Bulk load: An unexpected end of file was encountered in the data file.
: Msg 7399, Level 16, State 1, Line 1
: The OLE DB provider "BULK" for linked server "(null)" reported an error. The
: provider did not give any information about the error.
|
|
