[Talismanic]

Is it possible to rename table field names with code. I have a spreadsheet that is beeing imported from Excel and I would like to set the headers once the table is imported into Access.

I know that I can have Access assign the first row as field names but that approach will not work in this case. Any ideas?

[Talismanic]

I did it with a Make Table Query by modifying the SQL like this:

SELECT Jobs.F1 AS JobNumber, Jobs.F2 AS JobName, Jobs.F3 AS Travel, Jobs.F4 AS PW INTO JobNumbers
FROM Jobs;

Thanks anyways!

[EAFiedler]

Keep up the good work Talismanic!

I'll mark this one as Solved

[YSB]

I believe there is another way to do it but I have to try it out first to make sure I don't give you incorrect code. I'm just bringing this thread back to the top so I don't forget to try it when I'm at my other computer.

[YSB]

I tried it out and it works. You can rename a tables fields in code like this:

CurrentDb.Tabledefs("NameOfTable").Fields("OldName").Name = "NewName"

[Talismanic]

Very cool, YSB. Doing it with code allows me more flexibility.