Make a table from a recordset

[telephoto]

I have a table with 220 records, I am interested in one field called "post" Value could be "A1", "A2" etc

I want to set up a table with each of these records as fields with a yes/no box (ie field name "A1" datatype yes/no)

It must surely be possible with tabledef somehow in order to save me a load of typing, can anyone help here please?

 

[telephoto]

Ok guys.
It's easy. Sorry I asked, the answer just came to me.
Forget tabledef.


For any wanting to do this, follow the instructions below.

Export the first table as an Excel file.
Open Excel and delete all except the column required to be the new field names. Sort by value if required. (In col A, say).
Select all the names, move to cell B1 and right click, Select paste special and transpose. Delete col A.
(In my case I wanted yes/no boxes, so in row 2 enter "true" for each cell)
Save the file

Back to Access and import data, type Excel, and accept the wizard's offerings.

voila!

Telephoto