|
|
Posted by John Bell on 09/04/06 09:07
Hi
BULK INSERT does not have a method to define quoted strings, therefore you
would also have the quotes within the column data. It is not a BUG it is
just that the functionality does not extend that far. If you want to import
this file try using the Import Wizard and DTS. If you want to request this
in a future version you may want to vote for it at
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127032
John
"Davor" <dsola@yahoo.com> wrote in message
news:44fbd9fa.7754203@news.t-com.hr...
> 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]
|