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

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

RE: append Txt file to Access

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

RE: append Txt file to Access

(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

RE: append Txt file to Access

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