473,322 Members | 1,620 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

combining info from two identical tables into one

I have a table on one computer and another table, same table info from different time frames, and I don't know how to combine the two into to one table. Using microsoft access.
Sep 8 '06 #1
6 9692
PEB
1,418 Expert 1GB
You need :

to attach the one of the tables into the database of the other and create a query
that is named append query

You can select this option from the menu Query / Append query

And then assign in which field of the appended query you will add the fields of the choosen query

If you aren't experimented with this kind of queries try with two tables that are samples! With no important data inside! It's better the sample tables to be with the same structure! :)
Sep 8 '06 #2
ADezii
8,834 Expert 8TB
I have a table on one computer and another table, same table info from different time frames, and I don't know how to combine the two into to one table. Using microsoft access.
How about trying a UNION Query?
ADezii
Sep 8 '06 #3
PEB
1,418 Expert 1GB
Oh! Sorry I thought to transfer data! If not the Union is the best solution! :)
Sep 8 '06 #4
The main user wants to see all the info in ther form view. Will the form view combine the tables?



You need :

to attach the one of the tables into the database of the other and create a query
that is named append query

You can select this option from the menu Query / Append query

And then assign in which field of the appended query you will add the fields of the choosen query

If you aren't experimented with this kind of queries try with two tables that are samples! With no important data inside! It's better the sample tables to be with the same structure! :)
Sep 8 '06 #5
PEB
1,418 Expert 1GB
After Using An union Query you can visualize the information in Form View but you can't Add or edit it!

So the recordset isn't updatable!
Sep 8 '06 #6
PEB
1,418 Expert 1GB
To do an Union QUERY you have to attach to the main database the suborinated database

Than

Create a new query in SQL View

SELECT * FROM My_Table UNION SELECT * FROM My_Table1;

And Name it my_union

It will show you the information from the both tables!
Sep 8 '06 #7

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

Similar topics

2
by: Kenneth Fosse | last post by:
Hi. I'm currently working on a project which involves the creation of a web page which reports selected data to customers from two back-end systems. I use ASP script language on IIS, the server...
1
by: Reidar Jorgensen | last post by:
I have several databases, identical in structure but with different data. Is there an esay way to combine all the data into one big database? There are six tables.
3
by: Flip | last post by:
I'm looking at the O'Reilly Programming C# book and I have a question about extending and combining interfaces syntax. It just looks a bit odd to me, the two syntaxes look identical, but how does...
48
by: phillip.s.powell | last post by:
MySQL 3.23.58 - 4.0.17 (yep, several database server instances, don't ask) I have database Spring with table Students I have database Summer with table Students I am tasked to produce a...
1
by: Tony Jones | last post by:
Can I have two ASP.NET site using the same membership provider settings? For this to happen, the applicationName would have to be the same, but what about the configuration of the <properties>...
6
by: robertmeyer1 | last post by:
Hi, There are several databases that have the same tables, with different reocrds. I need to be able to combine them all into 1 in an easy manner/best. How can I do this and are there potential...
1
by: scolivas | last post by:
Hi, I have 2 databases - ALdata & SPdata I have 2 tables - vewDemoData (in ALData) & vewDemoDataSP in (SPData) both of these tables are identical in design, only the records are diff. I need...
3
by: Ken Fine | last post by:
This is a question that someone familiar with ASP.NET and ADO.NET DataSets and DataTables should be able to answer fairly easily. The basic question is how I can efficiently match data from one...
0
by: Haas C | last post by:
Hi all, I'm a newbie to Access programming and am having a hard time performing what may seem like a simple task to you all. Here's what i'm dealing with: I have 10 tables which are formatted...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.