Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Table Field Names

Status
Not open for further replies.

Kib

Programmer
May 17, 2001
58
US
Hi, After a table is created
I want the data that is stored in the 6th row to become the Field Names.
Not sure how to change that information based on what is in the table.
Hope this makes sense. Thanks
Kib
 
Huh? I don't get this at all.. Why would you change the field names after creation? You would then have to redo all relationships to that table in code, no fun! And why the 6th row, what's so special about it? I guess it could be done, I just don't see why you would want to..

Joe Miller
joe.miller@flotech.net
 
Well there are no relationships to the table.
It is being imported from an excel file that someone sends to me, and it chages alot and the only thing that stays the same, oddly enough happens to be the fact that the 6th row has the field names
 
Why wouldn't you simply delete the 5 lines before you imported it? It would take a matter of seconds to do. I don't know how you would get to sixth line because you don't have anything that would define a row as the sixth line because there's no id #'s. I think your best bet is to preprocess it before import. Sorry that doesn't help much. Joe Miller
joe.miller@flotech.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top