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?
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
