Solved

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

Posted on 1998-08-20
1
163 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
1 Comment
 
LVL 1

Accepted Solution

by:
arunprakash earned 100 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Hibernate methods 2 71
post4 challenge 28 100
canBalance challenge 34 81
JQuery serialize and unserialize 8 78
In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008.  These same feature are in the MFC libraries that come with Visual …
Introduction: Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers).  Error trapping with try..catch to help the code run even if something goes wrong. Continuing from the seve…
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.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

776 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