Importing a logfile into Acess 2003

Posted on 2007-09-28
Last Modified: 2012-08-14
This is my first question here!
I'm trying to import a textfile from an internal webserver to my access database.
I can do this from a network drive but the same code causes an 'Internal Internet Error' when i specify the server location as the source.

this is the code i expected to work:

Public Sub autoImportPortalData()

Dim strInputFileName As String

strInputFileName = "Webserver address and filename "

DoCmd.TransferText , "Portal  Import Specification Test", "Schedule1", strInputFileName, False
End Sub

Thanks in advance
Question by:routrax
    LVL 119

    Accepted Solution


    Author Comment

    Hmmm, i just get a 'Compile Error: Sub or Function not defined' relating to 'PageContents'.

    I've set the reference to 'Microsoft Internet Controls'

    Is there something obvious i am missing?
    LVL 119

    Expert Comment

    by:Rey Obrero

    did you copy the function PageContents ?

    Author Comment


    I missed that half of the code!

    I does what it says on the tin, the best bit is actually understand most of the code ;o)

    a million thanks!



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now