Try the -R parameter
-R
Specifies that currency, date, and time data is bulk copied into SQL Server using the regional format defined for the locale setting of the client computer. By default, regional settings are ignored.
To get rid of your quotes, you need to define a BCP format file and specify the delimiter as , for all fields except make it ," at the start of the string and ", at the end of the string.
There are about a thousand BCP command line switches, and the format file option, that let you make BCP do just about anything - and blindingly fast.
Cheers
Peter
At 15:37 10/04/00 +1200, you wrote:
> 1/7/99 08:17:10,"CWXX0700P",13.40
> 1/7/99 08:17:10,"CWXX0700T",14.57
> 1/7/99 08:17:10,"CWXX0702T",2.21
I'm also finding I can't define the date format, so when I come accross an
entry for 13/7/99 the query fails, maybe this bulk insert isn't so good
afterall, or am i overlooking something blindenly obvious?
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
