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
Thanks in advance