I am trying to develop a web site in which the user can add records to the database from an admininstration section of the site. I'm using an access database (there will only be about 60 or so records at any time). I can create a page that makes the user fill out a form to add a record like the sample below...but I'd also like a place where the user can just upload a CSV file directly into the database. Can someone please help me? I don't know a lot about ASP, but I'm planning on doing it in DMX. I would greatly appreciate any feedback.
I have another quick question. Someone told me that if I link my CSV and my database...then I could upload a CSV file with the same name and it will overwrite it each time, thus updating my database. Is that possible?