Splitting tables

[MTSPEER]

Hi, I have one table that I would like to make into two tables. Is there an easy way to do this?I have too much information and want to split it up.

[alansidman]

what do you mean by splitting? do you have to many fields. Or to many records? What is the current table structure and what is the proposed structure. We need more information to help you.

[MTSPEER]

Yes I have too many fields. I Put alll this survey information into one table. Like the Person's name, number, address. etc. But I mistakenly put the survey questions and answers into the same table. And I want to move all that information to a new table

[alansidman]

Create a query with only the fields you want. Change the query to a make table query. Run. Do this as many times as necessary and then after you are sure you have all your data properly aligned, delete the primary table that you no longer need.

[MTSPEER]

So I can make a query and run it, and then turn that query into a table?

[alansidman]

Yes. If you change the query from a Select Query to a Make Table Query. With your query open in design view, look on the ribbon for the proper Icon

[MTSPEER]

Thanks a lot!!

[alansidman]

You are welcome. I just read your earlier thread. Here is a good read on data normalization that may help you.

http://www.deeptraining.com/litwin/d...aseDesign.aspx