how can we transfer data from one access database to another databse . the table name is same for both the database . in one table some records are there (rs say e.g.) now another table has say rs+10 records . now i have to pass there 10 values to another table with same name . can anyone help me with this . can anyone tell me how to transfer records using codes . please
-
-
I posted a reply on this fo you, it's probable you hadn't yet seen it. You can use the Update command to achieve this. I will search for a tutorial for you in A moment, must disappear for a bit...
Good luck!
Dököll -
I should perhaps mention, you will need to use inner join in your update statement to allow both database to interact. This is just in case you wish to give it a whirl before I post the tutorial. I cannot find one that is easy to understand. I will post a code, if I have no other options.
You may consider adding a post to the acces forum as well, just in case...Comment
-
i m not using sql statement i m using dao . i m not able to get the required fields in my table . please help me with that. i m able to get the table from other database with same name but the no data.Originally posted by DököllComment
-
You got me, partner...I am not skilled at DAO. Since you have something working already, post it. You'll be surprised the type of help you can gather if one can take a closer look.
You may also consider searching a little deeper here. It's probable something is already posted. I wish you luck in this project.
In a bit!
DököllComment
-
Originally posted by rajaaryan44
DATA TRANSFER METHODComment
Comment