new table from existing table

[Guest]

I'd like to use an existing table to create a new table.
The existing table contains one record with 82 fields.

In the new table I'd like to create records from the existing
tables' fields - 82 records. I'd also like to create a new field
that increments for each of the fields added as a new record

From this:

Field1 Field2 Field3
val1 val2 val3

To this:
CountID FieldVal
1 val1
2 val2
3 val3

 

[Smartin]

I'd like to use an existing table to create a new table.
The existing table contains one record with 82 fields.

In the new table I'd like to create records from the existing
tables' fields - 82 records. I'd also like to create a new field
that increments for each of the fields added as a new record

From this:

Field1 Field2 Field3
val1 val2 val3

To this:
CountID FieldVal
1 val1
2 val2
3 val3

First thing that came to mind: if your table is really just one record
with 82 fields, a very quick solution would be to use Excel. Copy and
paste the original table in Excel. In Excel, copy the region and Edit
| Paste Special | Transpose. Add a "CountID" field and populate to
taste. Import the transposed Excel data back in Access as your new
table.