Moving data from website contact form into Access Database

#1 (**permalink**) 03-Nov-2005, 11:35 AM

What is the best way to move information that is entered into our website
Contact form into our Access Database?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6533-moving-data-website-contact-form-into.html

*

#2 (**permalink**) 03-Nov-2005, 11:35 AM

"spencergb" wrote in message
news:AAB293F6-427F-40A7-815B-1536CACC9AC0@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6533
this website for details:

http://www.asp101.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6533

#3 (**permalink**) 04-Nov-2005, 15:19 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6533
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" wrote:

> "spencergb" wrote in message
> news:AAB293F6-427F-40A7-815B-1536CACC9AC0@microsoft.com...
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6533
>
>
>
>

#4 (**permalink**) 04-Nov-2005, 15:20 PM

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.

"spencergb" wrote in message
news:6EAE4367-5329-43B2-9DD8-88092869FC06@microsoft.com...
> 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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6533
>
> Thank you.
>
> "Ron Hinds" wrote:
>
> > "spencergb" wrote in message
> > news:AAB293F6-427F-40A7-815B-1536CACC9AC0@microsoft.com...
> > > What is the best way to move information that is entered into our
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6533
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
> >
> >
> >
> >