bcp should be able to handle this - which is MSSQL's native way of bulk
copying stuff into the database.
RTFM for more info on it.
N
--
Nic Wise - 021.676.418 / [EMAIL PROTECTED] / Inprise/Borland New Zealand
Is it not a foolish man, said little Woo, who keeps all his chickens in his
trousers?
For at best, will he not suffocate his chickens, and, and worst, will he not
disappoint the ladies in the village? --Alexi Sayle
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Derricutt
> Sent: Friday, 7 April 2000 15:02
> To: Multiple recipients of list database
> Subject: [DUG-DB]: Importing text files to SQL7
>
>
> I have to import a textfile of data into an SQL7 table, the data is in the
> form:
>
> 2/7/99 08:29:09,"CWXX0700P",13.48
> 2/7/99 08:29:09,"CWXX0700T",17.43
> 2/7/99 08:29:09,"CWXX0702T",6.88
> 2/7/99 08:29:09,"CWXX0715A",99.90
>
> At present the code handling it (original code from when it was paradox
> based) is reading the file line by line and doing TTable.AppendRecord
> (simply modified to use TADOTable thou).
>
> I was thinking about passing the file into an INSERT SQL statement,
> putting 100 of so insert commands in a string and passing that to SQL
> Server in one go. Although I don't how good that is :)
>
> Does anyone have any suggestions?
>
> --
> 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: <no audio cd present>
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
