Split a table into two

[flaghippo]

Hi all
I have a table which basically has got too large far too many fields
I need to split into two tables and then link
Does anyone have any ideas how to do this ?
Thanks
Flaghippo

 

[David R]

What are your fields?

I'll bet you even money that you need to normalize your database, rather than split your table in half. Google it or search the forums.

 

[flaghippo]

Hi thanks for your reply
My table has go far too big approaching 256 fields
I Could easily split Into 3 or 4 tables and then link together
The table has a few thousand records so I need to find as easy way do this.
Thanks flaghippo

 

[David R]

Please list any fields you have that end in 1, 2, 3, 4, etc. Or upload a screencapture of your table Design window.

Access is NOT a spreadsheet.

 

[Rabbie]

Hi thanks for your reply
My table has go far too big approaching 256 fields
I Could easily split Into 3 or 4 tables and then link together
The table has a few thousand records so I need to find as easy way do this.
Thanks flaghippo

I agree with David R that your table is almost certainly not normalized. Access tables should be slim and tall not short and broad.

Use google to research database normalization. The academic sites are often the best for this.

This link will give you an overview.