> bcp should be able to handle this - which is MSSQL's native
> way of bulk copying stuff into the database.
Excellent, works like a treat :-) However, one thing... my data file is
like this:
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 getting "CWXX0702T" inserted into the tables with the quotes, I thought
I could get around this by defining the column seperators as ',"' and '",'
but I can't seem to use a quote as a column seperator.
Any ideas?
--
Mark Derricutt "People in prayer for me, everyone there for me,
ICQ: 1934853 sometimes I feel I should face this alone, my
Wrk: 377-9941 soul exposed... it calm's me to know that I
Fax: 377-9947 won't!" = Dream Theater - Scarred
DDI: 375-3754
Now Playing: Control Denied - Breaking The Broken
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
