By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,101 Members | 1,359 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,101 IT Pros & Developers. It's quick & easy.

Data Transfer from one Access database to another

P: 11
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
Mar 21 '07 #1
Share this Question
Share on Google+
5 Replies


Dököll
Expert 100+
P: 2,364
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
Mar 22 '07 #2

Dököll
Expert 100+
P: 2,364
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...
Mar 22 '07 #3

P: 11
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...
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.
Mar 22 '07 #4

Dököll
Expert 100+
P: 2,364
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öll
Mar 22 '07 #5

P: 1
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

DATA TRANSFER METHOD
Apr 5 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.