How to Export two tables data into one big table

[wg26]

Hi, Everyone:

I am trying to do denormalization. I created one big table which has all the columns included in two seperate tables.Now I want to export these two table's data into this one table. But since these two table's relationship is one to many, I am wondering how I can export data from these two tables to this one big table without losing any data. Can anyone give me some suggestions please. Thanks...

 

[CasperTFG]

I hope this doesn't look to cryptic, but the gyst of it is there:

SELECT [field1].[table1],
[field2].[table1],
[field3].[table1],
[field2].[table2],
[field3].[table2]
FROM table1 INNER JOIN table2 ON
[field1].[table1] = [field1].[table1]; Craig, mailto:sander@cogeco.ca

"Procrastination is the art of keeping up with yesterday."

I hope my post was helpful!!!

 

[wg26]

Thanks CraigSender. It's very helpful.
But I guess what I really want to do is to physically export data from these two tables into the one big table I created. From query you have given is more like to retrive the data from two tables instead of exporting them into another table.Is there a way to do it? Thanks...

 

[wg26]

I have got it solved...Thanks!

 

[gman2002]

What did you wind up doing to get this to work?

Thanks

G

 

[wg26]

Actually, it is not that hard. But my method may be not the best way to go. But it works anyway.

I first created one large table, which includes all the columns from two tables.
And then, I created a view by using these two tables.
And the last I did was to import the data from this view. Hope it helps.

 

[CasperTFG]

Or what you could do is this. Make the query so that it simulates what you want your recordset to look like. Then use the DTS (Data Transformations Services) Engine.

Run DTS, it opens up a wizard, the first page you select the database with your tables, the second page you select the database where you want to put the table, the 3rd page is table source. Choose Use a query to select records. Put your query in there, then the next page you choose a destination, this can be a new table.

Exoprt the data using the query from your old tables into your new big one. Craig, mailto:sander@cogeco.ca

"Procrastination is the art of keeping up with yesterday."

I hope my post was helpful!!!