Just use CFDIRECTORY to read the directories, A-Z. Then, loop over the
directory names and use CFDIRECTORY again to read all files. Loop over that
output and use CFFILE to read the files, one-by-one, and insert them into
the database.
-db
-----Original Message-----
From: Sudhir Duddella [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 27, 2000 9:47 AM
To: [EMAIL PROTECTED]
Subject: Regd. Bulk Insert into Database
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/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.
