Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ASP pages into Access 2000

    I have an ASP page from a WWW site (which unfortunately wants a password to allow access but I have it in Windows Clipboard format showing the screen view of the page, problem is it's 138k when zipped so if anyone cares to receive it, by all means drop a line <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>) displaying tabular data which I'd like to import into Access 2000 so I saved the page as an htm file locally and then used the following procedure in an Access 2000 module

    Public Sub prova()
    DoCmd.TransferText _
    acImportHTML, _
    , _
    "htmlEdison", _
    "c:tempedison.htm", _
    True
    End Sub
    but when I run it I get the following error message:
    Run-time error '2531': Your HTML file doesn't contain any tabular data that Microsoft Access can import.

  2. #2
    Giovanni
    Guest

    Re: ASP pages into Access 2000

    I have the impression that you mix everything up.
    ASP scripts (text files with .ASP extension) reside on the webserver and create dynamically HTML pages. These are sent to your browser and displayed on your screen.
    The HTML import function reads TABLE DATA with delimiters out of a text file with the HTML extension. Since your HTML file does not contain table data nothing can be imported.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ASP pages into Access 2000

    Thanks, are you Italian or just bear an Italian name?
    Ciao

Posting Permissions

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