also regarding the scheduled task, if the txt file is always going to be on the server it should be no problem once the code is written.
You'll just have to think how you're going to manage the txt file -----Original Message----- From: Mark Smyth Sent: 14 December 2001 15:20 To: CF-Talk Subject: RE: append Txt file to Access i see... well it is friday well basically if you need to upload (if its not on the server) and read the file using cffile get the data then create a list and loop through the txt file data populating the list (using list functions, read up in the cfstudio docs) then loop through the list (using cfloop) and have a cfquery inside inserting the data into access give it a bash and let me know if you need any help HTH Mark -----Original Message----- From: ronmyers [mailto:[EMAIL PROTECTED]] Sent: 14 December 2001 15:14 To: CF-Talk Subject: RE: append Txt file to Access I understand that. I was hoping I could do it through CF as the file changes and I wanted to use CFSchedule so it would update automatically -----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 7:53 AM To: CF-Talk Subject: RE: append Txt file to Access hi if you go to file - get external data - choose csv from the dropdown list and you should be away -----Original Message----- From: ronmyers [mailto:[EMAIL PROTECTED]] Sent: 14 December 2001 14:40 To: CF-Talk Subject: append Txt file to Access Can some on tell me or point me in the right direction on how to append a comma delimited .txt file to an access database. The fist line of the file has the same header names as the database. Thanks Ron Just a beginner in Cold Fusion, But think its an awesome program ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
