Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    access and WEB (2000)

    About BIG help from Hans i ahve undesrtand many Tips to connect a web page and retrieve a value from web and put in Excel.
    But is possible to use Access Macro and Table to have the same effect...?!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: access and WEB (2000)

    You wouldn't use macros (which have a special, limited meaning in Access) but VBA code in a module.
    The code to connect to a web page would be the same, this is not dependent on Excel or Access.
    The code to store values in a table would be different from the code to store values in an Excel worksheet, of course, but you already have code to fill a table using ADO recordsets.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: access and WEB (2000)

    ... but i can use mine various macro Excel and put value into Access Table?!
    For example, i have may macro to import value into Excel from web (tks you, nturally) similar:
    Put value from web into range excel and into same macro i can add line to open the connection to Acces and store the recordset into Acces Table... is this a good idea?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: access and WEB (2000)

    It might not be the most efficient solution, but it should work, and you already have all the code you need, so yes, I would do that.

Posting Permissions

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