I would create one batch file that runs the sql bcp utility
on each directory you need to process. Doesnt sound like
it will be a swift process any way you go.
-----Original Message-----
From: Sudhir Duddella [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 27, 2000 11: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.
