Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy data from html page and move it to Access XP

    Is there a way to copy data off a html page and paste it in Access XP? Maybe copy it as text and get it into Access XP? I have a LOT to copy and it would take weeks. There must be an efficient way to do this.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy data from html page and move it to Access XP

    Access will import HTML data as long as it's in a tabular format. I would recommend isolating just the table data you want to import, rather than trying to import a page with other information on it.

    If the format is not clean, you can past it into another application to clean it up (either HTML editor or Word Processor), then save it in a format that Access can read.

    Hope this helps...

  3. #3
    New Lounger
    Join Date
    Feb 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy data from html page and move it to Access XP

    Thanks Mark! This has been a BIG help. I was thinking I would have to buy more software to do this, but this is a great starting point. Thanks again.

    Mike

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Copy data from html page and move it to Access XP

    Check out a feature in Excel called Web Queries (Data > Get External Data > New Web Query). I just read about them, never used 'em, but they might be the smartest thing in Office if they work as described.

Posting Permissions

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