Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012

    Unanswered: Webquery to to append data from a website to a table in Access

    Hi All,

    I have a customer table in access and a website which holds some customer records

    I want to create a webquery in access that fetches the records from the website and appends those in my access table

    how do i achieve this ? Suggestions would be helpful please

    I am using Access 2010 version


  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Although I haven't used it myself for this purpose, I know that ADO supports web access using the Internet Publishing Provider.

    I've seen reference to using ADO for this purpose at ExtremeVBtalk. There's also a chapter in Rob MacDonalds excellent book "Serious ADO: Universal Data Access with Visual Basic" (APress)

    You would need to write a VBA module to retrieve the data.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts