Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to export records from a table to another table which is in other datasource???

Posted on 1998-08-20
1
Medium Priority
?
191 Views
Last Modified: 2013-11-20
We need to create tables dynamically.we could able to do this.Now we need to export records from a table to another table which is in other other datasource.(Ex : we need to exports recods in X table (access) to X table(oracle).We can get source and designation datasources(which is in odbc control panel)programmatically.Just i want to export tables or all records in a table to another datasource of different  type.

Could any body help us???

Thanks in Advance
0
Comment
Question by:MURALI_YAKKALI
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
arunprakash earned 200 total points
ID: 1321106
Hi i think u can do it this way,

CSourceRecordSet mSourceSet;
CDestRecordSet    mDestSet;

//set the filters
mSourceSet.Open();

if(!mSourceSet.IsBOF())
 {
 mSourceSet.MoveFirst();
 do
      {
      mDestSet.AddNew();
      //Call a function that moves data from the source record set to the destination
     mDestSet.Update();
     }
while(!mSourceSet.IsEOF())
 }
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you use Adobe Reader X it is possible you can't open OLE PDF documents in the standard. The reason is the 'save box mode' in adobe reader X. Many people think the protected Mode of adobe reader x is only to stop the write access. But this fe…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

598 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question