One table to many tables?

[elli]

Hi there!
I have an access table that could do some normalizing.... Is there any way
to separate table's columns into new tables? I do hope so

Thanks
-elli-

 

[Steve Schapel]

Elli,

Yes. The specifics of how to do it will depend on the details of yur
table and what you want to achieve. But in general it is likely to
involve running a series of Append Queries and Update Queries.

 

[nanne]

the easiest way is to copy the table rename it and delete the unwanted
colomns

 

[Steve Schapel]

Nanne,

You would need to attend to correctly setting up the joining fields
between the tables.

 

[G. Vaught]

I believe that Access has a table analyzer built-in that you can use and it
will recommend how to split your table. If I remember correctly, it will
split up your tables for you. Make sure you make a copy of your database
before using this feature.