Moving data from website contact form into Access Database

[Guest]

What is the best way to move information that is entered into our website
Contact form into our Access Database?

 

[Ron Hinds]

What is the best way to move information that is entered into our website
Contact form into our Access Database?

That depends on a number of factors. But the simplest way is to UPDATE the
database directly from the page your Form data is POSTed to. If your website
is hosted on IIS, and using ASP, you can use ADO to do the update. Refer to
this website for details:

http://www.asp101.com

 

[Guest]

Ron,

Thank you for your help, but I don't think I did a very good job of
explaining what I would like to do. I apologize for not elaborating nearly
enough. Please allow me to rephrase my question.

My clients will be entering information into a form on our company website.
Before adding this data to my Access DB, I need to review/approve the
information in ensure the quality of the DB. After the information has been
approved, I would like to save the into the DB. I am not sure if this is
possible, but I would like to have our website automatically generate and
send an email to me. The email would have two features: an xml record as an
attachment and the client entered information contained in the body of the
email in a format that is easy for the QA person to digest. Upon QA
approval, the xml record would be opened using Access or somehow moved into
Access so that our DB could be updated with the new client data.

Is this possible? If not, do you have any suggestions?

Thank you.

 

[Ron Hinds]

It's possible to eMail you with data from your web application. I use the
CDONT ActiveX library (built-in to NT/2000 systems). Again I would suggest
looking at the ASP site I gave you the link to. It might be easier to import
the data to Access if you send it as a comma-delimited text file, though. If
you use XML then you will need to write some code using the XML parser SDK.