Copying a file to FTP site

[DougHomeOffice]

Getting an error Bad File name.

I'm trying to copy a file from my computer to an FTP site
Is this possible how can i automate

--------------------------------------
Dim stDocName As String
Dim SourceFile, DestinationFile

SourceFile = "MyComputerPath\MyAccessFile.mdb" ' Define source file name.
DestinationFile = "ftp://usernameassword@domain.com/FolderAtSite/MyAccessFile.mdb" ' Define target file name.

FileCopy SourceFile, DestinationFile ' Copy source to target.
-------------------------

 

[chrisbee]

0Not sure if this helps but - I am doing the same sort of thing. the sysntax I use - that works is:-

datenow = datenow + rand & ".csv"
FileName = "FTP:\\ftp.yourftpsite.com\" + datenow
DoCmd.TransferText acExportDelim, , "FTPManifest", FileName, True

So I think you are missing the second ftp...
FTP:\\FTP.yourftpsite.com

Hope it helps

 

[DougHomeOffice]

What about UserName and Password?

-DOug

 

[DougHomeOffice]

And my slashes are different

-Doug

 

[DougHomeOffice]

ftp://usernameassword@domain.com/FolderAtSite/MyAccessFile.mdb

I tried:

ftp://usernameassword@ftp.domain.com/FolderAtSite/MyAccessFile.mdb

same error