I've not used it on files as large as is under consideration here,
but I've had good luck with SQL7 Bulk Insert, both from Query
Analyzer and in a CF app. The following is an example of the
former:
BULK INSERT Victor
FROM 'D:\FR\FileResource\VictorJPGs\CSVs\June202000\4347003.csv'
WITH
(
FIELDTERMINATOR='|',
ROWTERMINATOR='
'
)
best, paul
At 10:51 PM 6/30/00 -0700, you wrote:
>MS SQL Server Books On Line - search on:
>
>Bulk Insert or Bulk Copy Command or BCP
>
>Maybe create a sp and execute as follows?
>
>The BULK INSERT statement can be executed within a user-defined transaction.
>Rolling back a user-defined transaction that uses a BULK INSERT statement
>and BATCHSIZE clause to load data into a table or view using multiple
>batches rolls back all batches sent to SQL Server.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
