If you can do SQL2000, I'd recommend looking into the BULK INSERT function. Poke around your online docs a bit, and feel free to hit me up off-list with specific questions.
--Scott At 12:37 PM 3/17/2003 -0500, you wrote: >Hi All, >At regular date intervals, I will be provided (or be able to retrieve) via >web a tab-delimited list of employee names, addresses, etc. This .txt file >has a header row, and the position of the fields will not change. (ie, ID, >employee type, first name, last name, ...) There are about 500 employee >records in this file. Some records may have empty individual fields. > >What I want to do is automatically port this to a database, such as Access >or SQL 2000, then be able to do searches, based on a field name. I know how >to do everything after getting it ported to the database. I guess I don't >know where to begin on this, CFHTTP, using list functions, etc. Any ideas, >methodology or links to articles / tutorials is greatly appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
