new table from existing table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

uarctos - 20 Nov 2007 19:11 GMT

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

Reply to this Message

Smartin - 21 Nov 2007 00:13 GMT

> I'd like to use an existing table to create a new table.
> The existing table contains one record with 82 fields.
[quoted text clipped - 13 lines]
> 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.

Reply to this Message