vinidel Posted March 16, 2004 Posted March 16, 2004 Hi All, What would you suggest would be efficient and easy way of transfering data from one database(ORACLE) to other database(ACCESS), if I have to transfer only two tables limited data, but more frequently. ? Would I have to open two datasets and then update one with other.? Thanks in advance for any suggestion or advice Quote
*Experts* Nerseus Posted March 16, 2004 *Experts* Posted March 16, 2004 Do you really need a copy, or can you use Access's linked tables (or whatever they call them)? Can you use Access to import the data? What about another tool? If you must do it manually, through code, I'd use a DataReader to Oracle and direct INSERT calls to Access. But unless you really need to do some data manipulation that requires custom code, I'd try to use any existing bulk copy methods you can (as mentioned above). -ner Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.