you need:
Hmmm, maybe. I haven't used bulk insert in a couple years. This is the
syntax I've used before:
BULK INSERT SomeTable
FROM 'c:\temp\filetoinsert.txt'
WITH
(FIELDTERMINATOR = '|',
ROWTERMINATOR = '~')
So I figured you'd have to write the 50,000 records to
c:\temp\filetoinsert.txt (i.e. any file)
What syntax are you using?
Steve Nelson
-----Original Message-----
From: Paul St. Amant [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 7:09 PM
To: CF-Talk
Subject: Better way of inserting lots of data?
I have the thrilling job of inserting 4 years of daily stock results for
over 100 companies into an online database. I grabbed the data from
another system (not online) and created a macro in Excel to give me a
text file, which is then read and parsed by CF. No problems yet.
Looping over the data I create over 10K records and sit and wait and
wait and wait. Anyone know of a way to stuff an array or structure into
a database table in one fell swoop?
Thanks,
Paul
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
