just use CF to call a DTS using CFEXECUTE
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2002 15:40
To: CF-Talk
Subject: Importing a text file into SQL Server table
Hello list. I have a text file that is comma and double-quote separated,
with a line
Well you can also schedule the DTS package to run nightly or
at anytime you desire. If in fact it is a scheduling thing you are
looking for.
Not sure how you are reading your file, however, if you can read
line by line (CustomTag in the Gallery I think), the do a LOOP
over your read statement
If the file is large, you can use cfexec to BCP the file into a table then
run a stored procedure to process the table and put the data where it really
needs to be. If the file is small, just loop through it and do a series of
inserts then call a stored procedure to process the table.
Justin
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C019D6.3AD9C07E
Content-Type: text/plain;
charset="iso-8859-1"
use single quotes.
#Replace('#f1_element#','"','','ALL')#
HTH
Like this
#Replace("#f1_element#","Chr(34)"," ","ALL")#
--K
-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:05 PM
To: [EMAIL PROTECTED]
Subject: Importing a text file
I have a file that I need to import that looks something like
5 matches
Mail list logo