via vb 6.0, please split access table

[sal21]

In table STRADE, have a field named REG.

With:

CAMP
CAMP
CAMP
PIEM
TOSC
TOSC
....
VENE
VENE
VENE
VENE

Now i need to devide the table STRADE in a single table based REG with all data refered REG

Note:
Maintain original table
i just have a blank table named TEMPLATE with only structure of table STRADE

 

[strongm]

Are you saying you want to break the data out into b multiple tables? If so, why? I ask because you are potentially complicating things for yourself down the line.