By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 2,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

Transfer data from one database to another from a 3rd database

P: 3
I have data on a shared drive that needs to be transferred to a local drive. there are about ten databases that need this. I then have a central database that links all these databases together. I would like to be able to transfer data from the shared drive to the local drive from the central database. I cannot find anything on this in Help or online. Does anyone know how to do this?
Feb 13 '08 #1
Share this Question
Share on Google+
3 Replies


P: 17
I have data on a shared drive that needs to be transferred to a local drive. there are about ten databases that need this. I then have a central database that links all these databases together. I would like to be able to transfer data from the shared drive to the local drive from the central database. I cannot find anything on this in Help or online. Does anyone know how to do this?

Try linked table. Create a database on your local drive and link the required database objects from their previous location.

Or you can use sql to extract the data from the linked tables into your own tables that you would create on your local drive.
Feb 13 '08 #2

P: 3
I cannot link, our shared drive is extremely slow which is why this has to be done on the local drive.
Feb 13 '08 #3

Khriskin
P: 20
I think I have a similar situation to what you are describing, but I'm not quite sure how you have your databases setup.

I have the back ends of my databases sorted on the server (which bogs down quite a bit) and the front ends stored locally. In order to reduce the load on the server I have several of the tables that are not changed by the front ends stored as local tables within the front end programs. Every time the local program opens it checks the 'last updated' field for the local table against the 'last updated' field from the server's master table. If there have been changes, it links to the master and runs and update. If there haven't, it skips the update.

If that sounds like what you were trying to do I can give you more of a breakdown on how I set mine up.

Hope that helps! ^_^
Feb 13 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.