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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists