At 01:12 PM 7/27/00 -0600, you wrote:
>Just use CFDIRECTORY to read the directories, A-Z. Then, loop over the
>directory names and use CFDIRECTORY again to read all files.
At this point I'd drive the following in a CFQUERY loop
substituting the correct filename each loop.
BULK INSERT Victor
FROM 'D:\FR\FileResource\VictorJPGs\CSVs\July212000\101-200.csv'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR='
'
)
BULK INSERT is very fast. I've been told SQL7 /BOL/docs tell you how to
get fancy with FIELDTERMINATOR, etc.
best, paul
> 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.
------------------------------------------------------------------------------
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.
