Thanks Ryan, that definitely gives me something to work off of.
-----Original Message----- From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 7:30 AM To: CF-Talk Subject: RE: text file to database Hi Greg, I found this at Christian Cantrell's webblog. It's not exactly what you need, but should get you started. -- CC Says -- Anyway, did you know that CFHTTP can automatically turn a comma-delimited file into a query object for you? Let's say you have a file called data.txt that looks like this: firstName, lastName, emailAddress Christian, Cantrell, [EMAIL PROTECTED] Mike, Chambers, [EMAIL PROTECTED] Baby, Blue, [EMAIL PROTECTED] The following use of CFHTTP will parse the data above into a query stored in the variable "myQuery": You can use the columns attribute of the CFHTTP tag to specify a different set of column headers, and you can use the firstrowasheaders attribute to include the first row as data rather than column headers. And, of course, your comma-delimited file doesn't have to be static; the delimited values can be dynamically generated by any means. -- /CC Says -- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 5:23 PM To: CF-Talk Subject: text file to database I have a text file.. a huge text file.. looks similar to this except it has 20+ columns and 4000+ rows 555 123 0000 9999 555 234 0000 9999 555 345 0000 5999 Is there a way to take this data and dump it into an oracle database? Currently I use SQLLdr but would like to build some type of interface that would allow users to take an excel spreadsheet or text file delimited by tabs and enters and dump the data into the database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
