Access Guru Required.

[Da[]San]

I've just been provided two access tables from a customer which i need to combine into just one table.
They are called
BOM Extract 6J All and BOM Extract KV All

Each of the tables has the following field names, with data.
Product_No
PRODUCT_PLATFORM
Product_Desc
Intro_Date
Warranty_Code
Product_Line
Part_No
Part_Desc
Commodity_Code
Price
Labor_Level
Orderable_Flag
Defective_Return_Flag
Segment

I need all of the data from the two tables to be merged into 1 table which is just called BOMS

Is there an SQL available to do this?

 

[Eddie]

I couldn't accurately tell you how to do it off the top of my head as it's been too long since I last used Access, but if you Google for 'merging two access tables' you should find what you're looking for as it's quite a common thing.

You'll probably find that it's not as tricky as you think it is too.