How to Copy Data from Oracle DB to Access DB in C#?
Posted on 2006-06-25
I have the same exact table structure in both the Oracle DB and the Access DB. Both DBs are installed in one PC which my C# (.NET 2.0) application will run from. However, the Oracle DB is the source one. So what I want is to copy a portion from the source Oracle DB (the portion is a specific SQL SELECT statement) to the Access DB.
I could get the data from the Oracle DB using an OracleDataAdapter and store the data in a DataTable, like this:
OracleDataAdapter da = new OracleDataAdapter("SELECT * FROM R151BTS WHERE BSC=1, MyConnection);
DataTable dt = new DataTable("dt");
But after that, how could I copy the data from the DataTable 'dt' to the Access DB?
I might be wrong with my above procedure, so if anyone could suggest to me an optimized way to do my request, I will be really grateful.