Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Web Page (Access 2000)

    I have to copy many addresses from a web page into a table. I have to write down each address separately and there are hundreds of them.Is there any tool with which to convert the addresses into the table and thus save the efforts ?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Web Page (Access 2000)

    Can you send the URL of the webpage and i'll take a look at it tomorrow.

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

    Re: Web Page (Access 2000)

    Can't you copy and paste the entire list?
    If you can't paste directly into the Access table, you may be able to paste into Excel, then import the Excel table into Access.

  4. #4
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Page (Access 2000)

    Thank you for your reply.The fist page of the list is :
    http://catalog.bg/branch.php?id=8

  5. #5
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Page (Access 2000)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    Thank you for your reply.The fist page of the list is :
    http://catalog.bg/branch.php?id=8

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

    Re: Web Page (Access 2000)

    So you need many addresses from many web pages (the page you referred to mentions "915 results on 92 pages").
    You'll need someone who knows how to read and manipulate web pages in code to help you - let's see what Patt says tomorrow.

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Web Page (Access 2000)

    Cant do anything about this as i have too much work on.
    If you can get the source into a file and process the file to put the links into a table.

    Jefferson has the answers to this.

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

    Re: Web Page (Access 2000)

    I'm afraid we're not able to help you with this (the Jefferson mentioned by Patt is not available at the moment). Perhaps you could contact the firm that publishes the Business Catalogue and ask if they have the data available in a text file, spreadsheet or database. That would enable to to import the addresses directly.

  9. #9
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Page (Access 2000)

    Thank you anyway very much for your reply. You have always been very obliging and professional.I want to expres once again my appreciation since it was because of this Lounge that i have a working and efficient programme.

    Solar

Posting Permissions

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