Capture data in csv file or Access database
by Susan Alston
on
Nov 5, 2009 at 2:22:32 pm
I am new to Dreamweaver, but have had an introductory course, and worked on a couple of websites. What I need to do is find a way to capture application data off a form and enter it into an Access database. (I do not want to just e-mail the data somewhere). I know I can create the form in Dreamweaver, but I am not sure about the best means (software, etc.) to capture the entered data. It seems Spry can only help display and validate data on your site. Do I need to take a class in ASP? AJAX? We have a Windows server for our website. What are some of the easiest options for best doing this?
Re: Capture data in csv file or Access database by Fernando Mol on Nov 6, 2009 at 3:29:30 pm
My guess is you can store the data in a web database and then download it, then import it to Access.
For that, yes, you need to learn how to use a web database.
Access is a good app for local databases but it gets complicated when you try to communicate with web data.
Dreamweaver have some easy to use behaviors for programming and databases. I personally use PHP/MySQL because are robust, well supported and free, but you need to check if your server support them.
*Remember to share a link to your site and to rate the posts. This is a free service for you and for us.
