routrax
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did you copy the function PageContents ?
ASKER
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
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
ASKER
I've set the reference to 'Microsoft Internet Controls'
Is there something obvious i am missing?