473,789 Members | 2,550 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Data Transfer from one Access database to another

11 New Member
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
5 2025
Dököll
2,364 Recognized Expert Top Contributor
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
2,364 Recognized Expert Top Contributor
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
rajaaryan44
11 New Member
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
2,364 Recognized Expert Top Contributor
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 CHAKRABORTTY
1 New Member
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

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

Similar topics

2
4549
by: jimb | last post by:
I need some advice on how to securely transfer data between two servers. Here is the situation. We have two sql servers that hold student data. I have full access to my sql server, but only write access to the main sql server on campus. I hope to use XML and SSL to transfer student data to the main server. As for generating the XML, I'll have an asp.net page set up in a secure directory that will generate the data in xml format. The...
1
7284
by: Nathan Bloom | last post by:
Hi, I have a procedure that transfer data from an Excel spreadsheet to an Access 2000 table. There is a start date and an end date in the range specified. One of the date fields transfers correctly and the other one transfers as a text field containing a number like 37917. In the spreadsheet both date cells are formatted as a date. The data in both fields are entered as dates (i.e. 10/27/03). The TransferSpreadsheet Command creates...
1
1587
by: Sean McKaharay | last post by:
Hey All, I am trying to write an app that will transfer data from one SQL Server to another. Here is my situation: I have 2 computers neither one is connected. I have the same database on both computers. I need to update the data at the end of the night to reflect the changes on the particular database. So the data collected on computer1 needs to get to computer2 and the data on computer2 needs to get to computer1.
15
4742
by: Marcus | last post by:
I created a VB.Net 1.1 application that iterates through all the tables in any basic Access 2000 database passed to it and generates the same table structure in a SQL Server Express database. The structure is created fine (with minor data conversions from one to the other, e.g. yes/no --> bit, memo --> text, etc). My problem now is transferring the data over from Access to SQL Server. I thought it would be a fairly straight forward...
20
37899
by: TC | last post by:
I need an automated procedure to copy data from an Access table to a SQL Server table. Speed is important. What is the recommended technique? I can export the data from Access, copy it via FTP, then import it into SQL Server. I've tried that, and the speed is acceptable. It is an ugly solution, however, and I expect to find a better one -- preferably a solution better integrated with the Access RDBMS. I've tried using an ODBC...
4
4634
by: Luvin lunch | last post by:
Hi, I've developed a worklist system in Access and I plan to deploy four copies of it to the four users that need it. I said I'll be deploying copies because there is no shared network in the cave I'm working in. Each of the users will have their own copy and work on it on their own machines. It's so 1989 I dunno what to do with myself. Anyway, the manager wants to get a copy of each user's data once a month. So to my problem. I...
0
1365
by: rajaaryan44 | last post by:
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
2
2193
by: rajaaryan44 | last post by:
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. i m usinf DAO . i wrote some codes in dao. i created a function : AddTableField i m writing it in module so that it can be access from...
1
1563
by: ewanm | last post by:
Hello, I'm trying to transfer data from an Oracle database into an Access 2003 database using VB code. I need to set this up so that it can be ran on a regular basis and I really would like to avoid using linked tables if possible. I can open 2 ADO recordsets (one from the Oracle database and the current Access database) and write from one recordset to another by moving through the records one at a time. I've tried .Update and...
0
9511
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10404
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10195
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10136
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7525
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6765
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5415
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4090
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2906
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.