• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

Importing a logfile into Acess 2003

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
  • 2
  • 2
1 Solution
routraxAuthor Commented:
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?
Rey Obrero (Capricorn1)Commented:

did you copy the function PageContents ?
routraxAuthor Commented:

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!



Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now