I have to read a few hundred rows of excel data into a database. A record for each row. I saw some CFCs that do this or at least read them into a list but I've not been able to get CFCs to work in our system so far and dunno why.
I'm looking for any thoughts on the process of doing this. Do I load in a file, and read the contents, then parse the data or maybe list_to_Array and then bring it in through looped INSERTS? That's my first impulse. Am I close? I'd like the data to be quickly in and setup. I'm using Oracle and CF6.1 thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203873 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
