Paul,
Have a look at Nate Weiss' custom CFX tag called CFX_CSVToQuery. You can
get it from his website. Here's the direct URL:
http://www.nateweiss.com/taggallery/CFXQueryColumns\CFX_QueryColumns.zip.
He also has the documentation on-line for the tag:
http://www.nateweiss.com/taggallery/CFX_CSVToQuery\CFX_CSVToQuery.html
What I've found is that its somewhat faster than CFFile, and is fairly
simple to use.
hth,
larry
--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]
Chaos, panic, and disorder - my work here is done.
--
Paul Sinclair wrote:
>
> I've been trying to figure out a method to suck the contents of a comma
> delimited text file into a SQL database on an automated basis. Is there some
> method of doing this via CF? I've looked in the devex for a tag but don't
> see any.
>
> I'm getting a text file every night from an offsite source and each morning
> I am manually importing the data to the db. I'm sure that CF can do this via
> a cfm template that is run as a scheduled task but I haven't figured out how
> to do it.
>
> Thanks for any help.
>
> Paul Sinclair
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
