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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
