If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field Name- Header Record
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. |
#2
|
|||
|
|||
Field Name- Header Record
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. -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|