combining multiple tables in to one master

[joebox8]

Hi,
At the moment i have roughly 200 tables in my DB, I am working on cutting this down to only 7 tables.


Lets say you have two tables with the same fields in each, one of the tables is empty(fields only).. How could I import the data of one into the other? The fields are in different positions in each table so at the moment when i run an INSERT query the columns don't line up...
When i import through the external data option it just creates a new table with a "1" on the end!
This would be very handy and Im sure im blind to the obvious answer...
Any help would be great!

[clean32]

i doint know if this is the best way.

i attach the table
then make a query with both tables in it, attached or do what ever you need to do to make the data look correct, then append or change that query to an append query.

[joebox8]

How exactly would you go about implementing this? sorry im not great with the old SQL stuff!

[clean32]

How exactly would you go about implementing this? sorry im not great with the old SQL stuff!

ok try making a query, then right click it, query type append, that should get you started

[orange]

How exactly would you go about implementing this? sorry im not great with the old SQL stuff!

Joebox8,

Do yourself some fundamental research to understand what you have and how to set it up. Take a good read of the first few topics a this site and get an understanding of the concept of normalization and Entity relationship diagramming (and the Hernandez process). A few hours spent here will help you immensely.

http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck.

[Rod]

Apologies for butting-in but I think you're in danger of making a mountain out of a molehill.

INSERT INTO target [(field1[, field2[, ...]])] [IN externaldatabase]
SELECT [source.]field1[, field2[, ...]
FROM tableexpression

The syntax shows you can cross reference the columns any which way you want.

Oh ... and to add to what Orange says: clicking on that little question mark unveils a treasury of useful, nay vital, information.