Transfer my query result to FTP ?

[Guest]

I got an application written in Microsoft Access (VB code).

I want transfer my Access Query result to a FTP folder.

DoCmd.TransferSpreadsheet method is works for if I want to transfer my query
as an Excel Sheet to a local folder.

Ex.
DoCmd.TransferSpreadsheet acExport, 8, strname & "A", “C:\temp\myFile.xlsâ€

But when I change this code to transfer my file to an ftp folder

For example.
DoCmd.TransferSpreadsheet acExport, 8, strname & "A", "ftp:// mostaff:
mostaff2sss@abcftp01/myFile.xls"

I get the following error

-----------------------------------------------------
Sss Reports couldn’t close database ‘ftp:// mostaff:
mostaff2sss@abcftp01/myFile.xls’
Your last change may not have been saved because an internal buffer was
locked by another user(whose name was given in the previouse message).
To avoid losing data, wait for the other user to finish using the record,
and then click OK again.
If you Cancel, you may lose that haven’t been saved.
--------------------------------------------------------------------------

I was thinking to save the file in a local folder suchas C:\temp then write
the VB code to ftp transfer the file to the ftp server.

Can any please help me with this. I’m really struggling here. Any ideas also
appreciate.

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

If you're using Microsoft's web interface to post, I believe that you can
type the names of the various groups into the Newsgroup box. Separate each
newsgroup name with a semicolon.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")

 

[Guest]

HI Douglas

Sorry abt the problem. I wasn't aware of that. But could u please tell me
how to
"send the one message to
all groups at once" .

cheers

raj