Split one table 164 fields into several tables
New Here so pls. forgive ignorance. Over the years I have added fields to my database expanding inventory and now my one table has 164 fields, which makes it more and more difficult to manage - although it works. How do I remdodel the 1 huge table with 3000 records into 6 smaller related tables the fastest way? Do I import relevant record info from 1 old table into each of 6 new tables or what? I have laboured countless hours over this, so many thanks for help and input.