|
|
Posted by Davor on 09/04/06 07:48
I'm trying to import data from flat file in table and have few
problems.
1. Field Delimiter is ',' (comma). If ',' occurs in quoted
string it is still treated as field delimiter. This is BUG or ?
2. In table I have datetime field that can be null, but bulk
insert reports error if in flat file is null or ''. It's OK only when
real date is specified.
Table:
create table AttachmentList (
Code integer not null,
ClassID integer null,
Description varchar(200) null,
ValidUntil datetime null,
constraint PK_ATTACHMENTLIST primary key (Code))
flat file.
1,13,'Naputak, CU 261098', ''
Thanks in advance
Davor
Navigation:
[Reply to this message]
|