how to use BCP with null date field

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to use BCP with null date field

Author

Topic

coreysan
Starting Member

13 Posts

Posted - 2008-05-28 : 14:22:15

My tests have shown that if you use BCP to import records with a
date field as " ", it won't work.

Is there a way to get BCP to accept empty date fields?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-28 : 14:25:18

Try specifying a format file for bcp. More detail here

www.nigelrivett.net/SQLTsql/ BCP_quoted_CSV_Format_file.html

coreysan
Starting Member

13 Posts

Posted - 2008-05-28 : 15:03:05

That URL doesn't connect for me. Is this correct:

www.nigelrivett.net/SQLTsql/BCP_quoted_CSV_Format_file.html

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-28 : 23:46:04

quote:
Originally posted by coreysan

That URL doesn't connect for me. Is this correct:

www.nigelrivett.net/SQLTsql/BCP_quoted_CSV_Format_file.html

yup. why cant you access it? I have tried and it works for me.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources