in reply to Re: Data export into text file
in thread Data export into text file

Hi Dga,

I was not aware that two databases can be open.

Would your suggestion work if one table that contains the data is on my hosting server provider while the database to which I want to export is located on my hard drive in Access?

Replies are listed 'Best First'.
Re: Re: Re: Data export into text file
by dga (Hermit) on Mar 17, 2003 at 19:10 UTC

    If you can provide a DSN suitable to open the connection from your local machine, you could use that database. If you have shell access at your provider then you may be able to use the DBD::Proxy modules to open a connection locally there and proxy it out so you can see if from your local machine. I would be sure to do this over a secure channel ie. ssh or the encrypting variations of the proxy and make sure that no one else can use the proxy otherwise you open up a connection for anyone to query your data. I believe the proxy modules can be set up to allow read only access which would mitigate the risk to a large degree on the remote end

    <remote-db> - <DBD::(rem db)> - <DBD::Proxy> #remote -> #local <DBD::Proxy> - <DBD::Access> - <Access>

    The connection between the Proxy modules being read only from external. The Proxy's can have an encryption set up between them etc.