Get file from sftp (winscp) with vba

[Bertrand82]

Hello everybody!

Is it possible to get at file (e.g. txt-file) from a sftp server and import to a new table in an ms access db?

As a suggestion with vba or other metod.



Br Bertrand

[ranman256]

I successfully use:

Function ExecuteWebRequest(ByVal url As String) As String
Dim oXHTTP As Object
If InStr(1, url, "?", 1) <> 0 Then
    url = url & "&cb=" & Timer() * 100
Else
    url = url & "?cb=" & Timer() * 100
End If
Set oXHTTP = CreateObject("MSXML2.XMLHTTP")
oXHTTP.Open "GET", url, False
oXHTTP.send
ExecuteWebRequest = oXHTTP.responseText
Set oXHTTP = Nothing
End Function

[Bertrand82]

Thank you ranman!

However realized this is a little to complicated for me.