Create new table ussing append query

[Olivier]

How can create a new table by using an append query on 50+ tables.
Can this be done by one query?

 

[Howard Brody]

You would use a MakeTable query instead of an AppendQuery

however...

If you're copying the same data 50 + times, you're doing something wrong with your table/db design. You shouldn't need that much redundancy ever. I'd take another look at what your data needs are and try to find a better way to do it.

If you have questions, or can provide more specifics, please reply to this post.

Howard Brody



----- Olivier wrote: -----

How can create a new table by using an append query on 50+ tables.
Can this be done by one query?

 

[Olivier]

Reason why I have that many tables: I've imported the worksheets from
an excell workbook. Each worksheet was a different serie, but they all
contain the same columns. I also know the DB design is better of with
on less tables, that's why I'm looking to get all in one table.