Probably A stupid question on Merging tables

[Tcmarsh43]

Sorry for the stupid question... I am trying to combined 6 tables I suppose with identical format. Lets say Tbl1,Tbl2,..Tbl6 All have (for examples sake) Columns with the names, "[Column Name], [Data Type], [Length], [Basic Name]". I am trying to create a query which makes a table with all these tables combined. I only care that the first column, [Column Name] is unique, the others will have similar matching data likely. I have tried using the graphic interface to try and patch a few things together but I always end up getting either silly errors or an absurd amount of entries.... If anyone could shed some light on this and assist me I'd be in your debt


Thanks,
-Tyler

 

[Cronk]

When you say
" only care that the first column, [Column Name] is unique", presumably the input tables combined have records with the same [Column Name].

What do you want to do with duplicates? Import the data but changing [Column Name] to something else for duplicate records, or not import them?

Either way, I'd import the six tables into your combined table allowing duplicates, sort out the duplicates, then change the table design to make [Column Name] unique.

 

[Tcmarsh43]

Okay I suppose that makes sense. However the only past experience I've had was combining tables that shared common data. What do you recommend? Sorry for the beginner level questions I tried to create a query which resulted in a table being made but I suppose I kept messing up somewhere along the line

 

[Cronk]

Use an append query, not a make table query. Even easier if you have the destination table, is to copy/paste append.