separate table

[ankit]

I have 70 thousand record in one table i want to separate record
in two table it is possible?
if any one know about it please help

 

[stopher]

I have 70 thousand record in one table i want to separate record
in two table it is possible?
if any one know about it please help

Sure. Maybe you could explain more about the structure of your table and how you want it separated. I would suggest you look at "Make table" queries as these will allow you to make a new table according to your requirements based on your old one.

By the way, why do you want to separate your table? 70,000 records should not be a reason to split data.

Chris

 

[Galaxiom]

I have a table with four million records and have not found any need to split the data. If you are having speed problems at 70,000 records you should review your queries to retrieve only the relevant records.