>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?
What kind of database?
I handle a lot of stock data. I considered using CF and dismissed the idea
that CF as a possible tool.
Perhaps you would be best served to do a bulk insert. The previous email
is a good example.
I'm not sure what you mean by grabbed the data? Using DDE from a quote
service to get it into Excel and then importing into a DB?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
