We recently wrote a conversion program that took a CSV file and converted it
to a set of database records. We imported the file into a Access database,
and then wrote an Access function that went through the tables, translating
and inserting them into the SQL Server database (through linked tables).
Effective when it only needs to be done one time.
Just an idea,
Scott
-----Original Message-----
From: JD Salzman [mailto:[EMAIL PROTECTED]]
Sent: Freitag, 14. Juli 2000 03:32
To: '[EMAIL PROTECTED]'
Subject: RE: Importing Large Text Files
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.
------------------------------------------------------------------------------
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.
