Making 2 tables in to 1

W

Wolfman

Guys,

Access 2002 SP2

I have 2 tables which have the same fields. They were for different suppliers, now we want it all on one. What I want to do is to make it one table. How do I add the 2 together without losing any data etc.
 
A

Arvin Meyer

I have 2 tables which have the same fields. They were for different
Click to expand...
suppliers, now we want it all on one. What I want to do is to make it one
table. How do I add the 2 together without losing any data etc.

You could simply append the data from 1 to the other, but I would prefer to
make a backup of one, then append the data. That way you can always start
over if you have a problem. To append the data, use an append query.

Another method would be to write a Union query:

Select * From Table1
Union All
Select * From Table2;

Then use that query as a basis for a MakeTable query. The first method is
easier for the novice, the second easier for anyone comfortable with writing
queries.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
W

Wolfman

Arvin,

Cheers, for that. Actually found an easier way though. Highlight one of the tables. Copy it and then paste. It'll give you the option to Append to another table. Therefore wrote the name of the other and sorted.

You pointed me in the right direction.
 
K

kerrpmb

This sounds like excel or a financial. Excel is neverending, but the thing
with excel is that it is an accounting spreadsheet. If it is a financial,
please let me know which one, because i am not too familiar with the
financials, but i would be willing to work on that one with you. Thank you,
because if it is Microsoft Dynamics and not a copy then you can inquire
within the windows pane, because it is workable software and it can be tailor
made. There may be cost incurred for a specially made order. Thank you.
 
A

Arvin Meyer [MVP]

Append Table 2 to Table 1 and the delete Table 2 after you are satisfied
that the append has worked. As usual, do it on a copy of the database to
make sure that everything goes as expected.
 
Top