How do I create multiple tables with one create table query?

[ferrisj]

I have 10,000 records and I need to make 50 tables with 200 records per table. I am trying to load this data into Microsoft Streets and Trips, and the only way I can group the records is to make the different tables.

 

[JerryKlmns]

If Microsoft Streets and Trips can read from MS Excel, export your table to excel and do that from there.
If excel 2003 create an extra column to define the 50 groups of 200 records, create a pivot table based on that group column (no groupping in data), and then on Pivot Table toolbar press the "PivotTale" menu button and click the last option "Show Pages ...". There you 've got your 50 groups in 50 sheets.

 

[lespaul]

Does each table have a different structure or the same?



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[ferrisj]

the exact same structure

 

[lespaul]

then you should read the Fundamentals document link, having 50 tables with the same structure is a definite sign of a non-normalized structure.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[ferrisj]

it is not for a database it is just a function of breaking the data apart so that it can be fed into this program.