473,893 Members | 1,663 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Append query from two tables with different fieldnames -- easy linking?

I've got two different tables with similar data but the fieldnames are
different and laid out slightly different. Is there a quick way to build an
append query where maybe I could draw lines between each field to associate
them to one another? The access append wizard will only match up fields
with the same names, but I have probably 100 others that are different.

Is there a way to quickly associate say:

table1:
a
b
c
d

with table2:
d
c
a
b

where table1.a = table2.d, table1.b = table2.c, etc.
Can access or some other utility make this association for me quicker
(something graphically) to build an insert/append query? This will save me a
ton of work.

Thanks in advance!
Nov 12 '05 #1
1 4240
If the number of fields is the same and field order is the same, a union
query should do what you want. It doesn't care about field names. If, on
the other hand, the field order is not the same, I think there is no
avoiding doing it by hand, one field at a time.

Pavel

Jason wrote:

I've got two different tables with similar data but the fieldnames are
different and laid out slightly different. Is there a quick way to build an
append query where maybe I could draw lines between each field to associate
them to one another? The access append wizard will only match up fields
with the same names, but I have probably 100 others that are different.

Is there a way to quickly associate say:

table1:
a
b
c
d

with table2:
d
c
a
b

where table1.a = table2.d, table1.b = table2.c, etc.

Can access or some other utility make this association for me quicker
(something graphically) to build an insert/append query? This will save me a
ton of work.

Thanks in advance!

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
49826
by: Girish | last post by:
I need to run a query which will pull data from two tables and append it as one when it displays the result. The data are in two tables. But the result set will be identical in terms of number of columns. I want to display it one set below the other. This is for pay history. From 2003 we have a new payroll system. Till 2002 we used to have a different system. But I need to run a query which will pull the data for an employee for the last...
3
10555
by: Dalan | last post by:
From reading Access 97 help text, it seems that to do what I need to do will require a Union Query. As this would be my first, I think I might require a little guidance. I have two tables with 10 fields that have like data (for instance both have an item description field, an item price field, a general notes field, etc.) but with different field names. The tables have approximately 20/40 other fields that are dissimilar and not needed...
1
1258
by: Jason | last post by:
I've got two different tables with similar data but the fieldnames are different and laid out slightly different. Is there a quick way to build an append query where maybe I could draw lines between each field to associate them to one another? The access append wizard will only match up fields with the same names, but I have probably 100 others that are different. Is there a way to quickly associate say: table1: a
3
2925
by: Larry Rekow | last post by:
As part of a macro, I'm trying to automate appending a table with new records. let's say the table 2 has some new records in it, but also has a lot of identical records to table 1. I would like to append table 1 with all of the new records, and do it unattended in a macro. Is there a way to specify in the append query to only append the
1
1762
by: sparks | last post by:
I have 4 databases that are all the same thing. These are from different sites but we made sure that no 2 databases are using the same id's and autoid's so all the tables are unique in their data and linking. but now they want to merge/append all of them into 1 database. there are 14 tables in each one that have to me consolidated into one. Is there a nice easy way to do this? I know I could manually append each table from each...
22
18826
by: RayPower | last post by:
I'm having problem with using DAO recordset to append record into a table and subsequent code to update other tables in a transaction. The MDB is Access 2000 with the latest service pack of JET 4. The system is client/server, multiusers based. The MDBs are using record locking. Here is part of the code: Dim wkSpace As Workspace, db As Database Dim rstTrans As DAO.Recordset Set wkSpace = DBEngine.Workspaces(0)
2
1486
by: john | last post by:
In the query builder I made an edit-query in which I have linked table A to table B on IDnr. For every record that matches I want 5 fields of table A to get the values of corresponding fields in table B. I'm able to make this query but only by typing the table B fieldnames in the 'change to'-row. Is there some easy way to drag those fieldnames to that row or another way to make this easier? Thanks, john
1
1788
by: rebexter | last post by:
I have a list of about 58,000 records which I created by merging numerous smaller lists, each of which contain a certain keyword. What I want to do now is update the master list of 58,000 records so that each line shows which of one or more keywords that record contains. For example, the original source tables contain the following fields: DocID, Keyword where DocID uniquely identifies each record no matter what table that record...
4
7613
by: franc sutherland | last post by:
Hello, I am using Access 2003. I am having trouble trapping the "can't append all the records in the append query" error message when appending data to a query from a table which is linked to an excel spreadsheet. There are two tables. One is a list of general contacts, and the other is a list of clubs. The clubs contain members who are within the contacts table. When I add a list of new club members from the
0
9985
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9832
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
11244
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
10469
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7173
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
5858
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...
0
6066
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4684
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
2
4280
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.