use vb, java, c ... and write a program to cycle through it
and call a stored procedure 4 insert.
or use BULK INSERT (although limited delim flexibility poses probs)
cf is not 4 everything
- hope this helps
> ----------
> From: Cold Fusion[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, July 13, 2000 10:55 AM
> To: [EMAIL PROTECTED]
> Subject: Importing Large Text Files
>
> I'm building an application that requires parsing
> through a very large text file (650,000 records) and
> inserting those records into a table. Any thoughts on
> how I would do this? I would imagine that CFFILE read
> would not be able to handle a file of that size.
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
