SQL 7.0 supports the SQL statement BULK INSERT
The syntax looks something like.
BULK INSERT sometable FROM 'c:\somepath\file.txt'
WITH (
FIELDTERMINATOR = 'your terminator',
ROWTERMINATOR = 'your rowterminator'
)
Good luck.
Mark
-----Original Message-----
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 06, 2000 7:07 PM
To: CF-Talk
Subject: SQL Job
ok I need help....
I have a text file that is ftp to me. Every Sat. night it comes with new
information and update information. Every Sunday mourning I want to they
text file, import the info. For each record if the idkey is not there
insert the record. if it is there, update the record. Also to put a check
to see if the date is 00/00/00 (if it is make it null).The file is somewhat
big, its got 91 fields and about 32 thousand records...I tried manually
importing the text file and it errored out when I selected the delimited
check box and on the next screen came up. But if I imported it into access
then from access to sql it worked great....
Any help would be very much appreciate
Thanks Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
