Help!! Text files

<i><b>Originally posted by : Kenneth Howlin (9625275@student.ul.ie)</b></i><br /><br />I have to do a final year project in college using ASPs adn stuff. I have to add, delete and update records in a database as part of this project. THe only thing is that my supervisor won't let me use Access or SQL Server or any other kind of database. SHe wants me to use text files. Can any one give me the code for adding, deleting, updating lines in a comma delimited text file. Thanks

<i><b>Originally posted by : steve schofield</b></i><br /><br />http://www.aspfree.com/asp/startpage.asp?id=13<br /><br />Here is a demo of how to create and append to a text file. also check out http://www.learnasp.com/learn/T.asp<br /><br />Charles has some nice examples too<br /><br />steve<br />------------<br />Kenneth Howlin at 2/2/00 6:37:15 AM<br /><br /><br />I have to do a final year project in college using ASPs adn stuff. I have to add, delete and update records in a database as part of this project. THe only thing is that my supervisor won't let me use Access or SQL Server or any other kind of database. SHe wants me to use text files. Can any one give me the code for adding, deleting, updating lines in a comma delimited text file. Thanks

<i><b>Originally posted by : Alan R. Parker (parkera@technosys.co.uk)</b></i><br />If you mean you wnat to use a CSV as an ADO/DAO target have a look at Robert Smith's site www.smithvoice.com. There are a number of examples using DAO. If you want to use ADO, declare a system DSN via ODBC control panel applet, using the text driver (you could use a dsnless or oledb conenction I suppose but whatever you like), point to the DIRECTORY where the csv file lives, on the options tab you can allow it to guess the format for your files, or you can tell it. Having saved the dsn, you get a schema.ini created (for all the text files in that directory), I've not tried updating/inserted but I have been able to query. The general syntax is <br /><br />"SELECT MyColumn, MyColumn2, MyColumn3 FROM MyTextFile.txt"<br /><br /><br />the MyTextFile.txt is the name of the file you are targetting your DSN at, its also the name of the section describing your file in the schema.ini file. You can certainly select *, and use orderby clauses etc with the provider, so I guess you'll be ok for upodates etc.<br /><br /><br />Arp