Export SQL database to Access97 via Ftp

[Guest_imported]

Hi,<br>with the export wizard or a dts package, I<br>want to export an sql database to an<br>access database situated on an ftp site<br>other than the sql server. But when the<br>sql server asks the destination to put the<br>access db, he always opens my computer.<br>How can I change this?<br>thank you for answering<br>

 

[DrSql]

I am not sure it will work or not, but give it a shot.<br><br><B>Step 1.</B><br>Select the <br>Data Source.<br>Server<br>Database<br>(You dB that you are exporting from.) <br>Next<br><B>Step 2.</B><br>Select the Destination as Ms. Access.<br>Then select the filename to browse.<br>At the select file type your ftp server name<br>It will try to search your network and try to locate the ftp server.(It might ask you for userid and passwd)<br>Then browse to the Ms. Access dB.<br>The rest same for any dB.<br>Good Luck. <p>Dr. Sql<br><a href=mailto:vpathisseril@yahoo.com>vpathisseril@yahoo.com</a><br><a href= > </a><br>Good Luck.