One table to many tables?

E

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-
 
S

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.
 
S

Steve Schapel

Nanne,

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

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.
 
Top