Better way of inserting lots of data?

[Paul St . Amant]

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]

---