Jon, Thanks for the responses. Sorry to confuse the issue. I was just listing the available options that I have, so any combination of the below versions would work. The solution does not need to work on all versions. I think I will look into DTS and see what I can come up with.
Thanks, Issac -----Original Message----- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 8:11 PM To: CF-Talk Subject: Re: Parsing a large text file The variety of databases and cf versions makes it a bit more challenging, but this cfx tag works well, and it's relatively quick at reading the text file. http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_us&view=sn13 1&viewName=ColdFusion%20Extension&extID=1000558 However you would still need to do a zillion inserts so I it's still not the most efficient way. It may gain you enough to be comfortable though. With SQL Server you can run through the import data wizard and save the import as a DTS package, then run the DTS from a stored proc call, or via command line with cfexecute and dtsrun. The necessity for Oracle compatibility may rule this out though. I'm sure Oracle has similar bulk import capabilities, if your up to writing two different import procedures... -- jon mailto:[EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
