Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Moving data from website contact form into Access Database

Discussion in 'Information Technology' started by spencergb, Nov 3, 2005.

  1. spencergb

    spencergb
    Expand Collapse
    Guest

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

    Similar Threads Forum Date
    Islam Moving Mountains Interfaith Dialogues Nov 29, 2012
    World Man punches nurse for removing wife's burqa Breaking News Dec 25, 2011
    SALDEF Stop Arizona From Removing Balbir Singh Sodhi from 9/11 Memorial Sikh Organisations Apr 27, 2011
    Moving Forward, Or Sliding Backward Sikh Sikhi Sikhism Oct 20, 2010
    Moving to Montreal, Canada Need Help! Community Out-Reach Oct 18, 2010

  3. Ron Hinds

    Ron Hinds
    Expand Collapse
    Guest

    "spencergb" <spencergb@discussions.microsoft.com> 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
     
  4. spencergb

    spencergb
    Expand Collapse
    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" wrote:

    > "spencergb" <spencergb@discussions.microsoft.com> 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
    >
    >
    >
    >
     
  5. Ron Hinds

    Ron Hinds
    Expand Collapse
    Guest

    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" <spencergb@discussions.microsoft.com> 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?
    >
    > Thank you.
    >
    > "Ron Hinds" wrote:
    >
    > > "spencergb" <spencergb@discussions.microsoft.com> 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
    > >
    > >
    > >
    > >
     

Share This Page