This tag will probably help out, you can use it with an INSERT or possibly
UPDATE if needed.
http://www.icesinc.com/nate/taggallery/SpaceDelimitedTextToQuery/SpaceDelimi
tedTextToQuery.html
-Adrian
> -----Original Message-----
> From: Randy Adkins [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 05, 2000 8:52 AM
> To: [EMAIL PROTECTED]
> Subject: Importing of ASCII Files
>
>
> If there any way to import a standard ASCII text file into
> a DB using CF?
>
> I can read the file using the CFFILE function but the
> variable is smash together where the text file is set as
> predetermined spaces and lengths of field data.
>
> I can possible using CFFILE and increment the counter
> of characters to read each time but I know there should
> be an easier way.
>
> Thanks.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.