Field Name- Header Record

[Mjohnson]

I have a large database (approx 900,000 records) with 95
fields. When the database was originally created there
was no Header Record, so all the fields are generic
(Field1, Field2, Field3, etc). I now have the Header
records for the Field Names, but I don't want to have to
key in each Field Name- Is there an easy way to do this
without having to key everyone in individually. I know
that when you import files, one option is to have header
record as field names- I was thinking that maybe I could
do something similar to this without having to reimport
and select that box.

thanks for any ideas or suggestions.

 

[Jeff Boyce]

You haven't described where the current database lives, but you're in an
Access group, so I'll guess it's in Access. Access doesn't have "header
records".

If you are importing this data from an outside database, you can use the
import wizard and specific that the first row contains field names.

95 fields doesn't sound like a well-normalized design -- to get the real
power out of the relational database Access provides, consider revisiting
the data structure.