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

Importing a logfile into Acess 2003

Hi,
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
Steve
0
routrax
Asked:
routrax
  • 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?
0
 
Rey Obrero (Capricorn1)Commented:

did you copy the function PageContents ?
0
 
routraxAuthor Commented:
Doh!

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!


Steve

0

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