Solved

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

Posted on 1998-08-20
1
140 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
configuration management 2 99
if loop in java 3 114
sum67 challenge 35 89
Not needed 13 54
Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms.  Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go.  MFC has a very cool system for handli…
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
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.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now