Importing Tables and merging them together

  • Thread starter Thread starter Alan \(madcat\)
  • Start date Start date
A

Alan \(madcat\)

Hello

I'm trying to merge several DB into one.
I have tided up the tables and now I would like to merge
all the tables into one table
Is there a way to do this?

I also will need to add to the table from time to time.

Thanks

Alan
 
Hello

I'm trying to merge several DB into one.
I have tided up the tables and now I would like to merge
all the tables into one table
Is there a way to do this?
Click to expand...

Append queries are designed for exactly this purpose.
I also will need to add to the table from time to time.
Click to expand...

I'd suggest creating a Form based on the table; this will let you add
data or edit existing data.

Do read up a bit on "normalized design" - there's good information at
Microsoft's website http://support.microsoft.com; search the Knowledge
Base for "Normalization". An Access database with only one table is
very unusual; as a relational database, you would ordinarily have at
least two or three tables, one for each type of entity (person, event
or thing) represented in your data model.
 
Back
Top