Re: How to transfer my access query result .xls file to a FTP Serv

Tech-Archive recommends: Speed Up your PC by fixing your registry

Go to File | Get External Data | Import on the menu, navigate to where
you've put the MDA, select it and select all of the objects in it.

Alternatively, make a copy of the file and change the extension of the file
to .MDB and see whether you can open that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CA1BFB00-A4D6-416E-979B-DEF6DA2F6DCB@xxxxxxxxxxxxxxxx
> Hi Douglas
>
> My MS Access version is 2003. So I do not have the InetTransferLib
> Library
> THe reference u gave me it says as follow.
>
> "
> To use this functionality in Microsoft Access 2000 or higher, please
> import
> all the classes from the addin (which does not have the tables required
> for a
> typical Access addin) in your own Access project. To use the classes, just
> refer to them with the 'InetTransferLib.' prefix (eg: Dim objHTTP As HTTP"
>
> Could u please tell me what it means by import all the classes from addin?
> I
> can't see the InetTransferLib in my Access references
>
> cheers
> raj
>
>
> "Douglas J. Steele" wrote:
>
>> Access doesn't recognize the ftp protocol (nor http, for that matter).
>>
>> You'll have to transfer the file to your hard drive, then transfer it
>> from
>> there to the ftp server. Check
>> http://www.mvps.org/access/modules/mdl0015.htm at "The Access Web" for
>> the
>> low-tech approach to doing this, or
>> http://www.mvps.org/access/modules/mdl0037.htm for a more robust
>> approach.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:22415C9D-151A-4A78-8E7E-F9F6B1FE0647@xxxxxxxxxxxxxxxx
>> >I got an application written in Microsoft Access (VB code).
>> >
>> > I want transfer my Access Query result to a FTP folder.
>> >
>> > DoCmd.TransferSpread*** method is works for if I want to transfer my
>> > query
>> > as an Excel *** to a local folder.
>> >
>> > Ex.
>> > DoCmd.TransferSpread*** 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.TransferSpread*** 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
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>>


.

Quantcast