|
| 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.
Cheers
Raj
|
|