split table

[rosito]

I have one table - 40 fields, 40000 records. Iwant split this one table up to 4 different tables (keep data). Is there an easy way, pls?

 

[Rabbie]

See Maketable queries,Append queries, Update Queries in Access Help. Once you have set up and populated the new tables you can delete your original table. Don't forget to run Compact and Repair when you are finished. You will also need to set up relationships between your tables as required.

 

[rosito]

i try with querie...unsuccessfully I'll try another atempt - with "Tools->analize->table"...What will happend..i'll see

 

[neileg]

Do you want 4 tables with ten fields and 40,000 records, or 4 tables with 40 fields and 10,000 records?

 

[rosito]

4 tables with different fields (4-4-7-25) and 40 000 records. Table Analyzer Wizard give me msg: "You can put at most 15fields in a lookup table"

 

[neileg]

Either:
1) Create 4 empty tables and use append queries to populate these with your data
or
2) Use make table queries based on your existing table to create your 4 tables

 

[rosito]

tnx...I did this..4 queries..but i want delete all useless info(and basic table, too). One simple macro did the whole work - export-import-delete... and now i have 4 different, full, complite, independent tables