Sudhir
Short of SQL Server's Bulk Copy Program, you can do it with a simple
CF template.
I don't think you want do do it all in one shot.... probably too long
& will get some timeouts.
I have had good results with CFHTTP reading each text file into a
query then looping through the query doing an insert for each row
(record) from the text file.
The program could do a few files, then return to the user (keeping
track of what file is next).
The returned page could have a metatag/javascript refresh to resubmit
the next request.
I have set things like this up and gone to lunch... when I get back,
the job is done!
HTH
Dick
At 8:46 AM -0700 7/27/00, Sudhir Duddella wrote:
>Hi ALL
>
>I have alphabetically listed Directories like A,B,C
>..Z and in each directory I have Text files averaging
>upto 500 text files in each directory.
>each text file has a approx. 800 to 1000 records of
>data.
>
>Now I have to Insert all these into a database in ONE
>Table. Does anyone can give me idea How to proceed to
>insert all in one single shot. I know one way but that
>is laborious process whwich consumes Hrs. Hrs of time,
>i don't want to proceed in that way.
>
>I am using ColdFusion 4.0 and Backend as SQL Server
>7.0
>
>Any help in this reagrds will be highly appreciated.
>Looking for an early reply asap.
>
>Thanx.
>
>
>
>
>__________________________________________________
>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/fusebo
>x 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.
