TransferText and FTP

[Mike_Walrus]

Hello i'm trying to upload a table onto my ftp server however when i try to
upload the file i don't know how to enter the username and password

if i use the code
DoCmd.TransferTextacExportHTML, , _
"Table1", "ftp://user[email protected]/public_html/table1.txt", True

i get the error:
"The Microsoft Jet database engine could not find the object
'ftp://user[email protected]/public_html/'. Make sure the object exists and
that you spell its name and the path name correctly."

but if i use the code
DoCmd.TransferTextacExportHTML, , _
"Table1", "ftp://@ftp.myftp.com/public_html/table1.txt", True

i get the error:
"Internet Login Failure"

Can someone help me out here?

thanks
Mike