Access - change field names programmatically ?

Question

Every month I import data from Excel into access - several field names (text format) need to have "GL"  in front of the name - instead of Sales, I have to go into the design view and change Sales to GLSales.  Is there a way I can do this programmatically ?  I could write a macro on the Excel side, but I would prefer to do it in Access - is there a way this could be done In Access

Answer 1

Every month I import data from Excel into access - several field names (text format) need to have "GL"  in front of the name - instead of Sales, I have to go into the design view and change Sales to GLSales.  Is there a way I can do this programmatically ?  I could write a macro on the Excel side, but I would prefer to do it in Access - is there a way this could be done In Access

I'd be inclined to link to the spreadsheet, rather than importing it directly, and then use an append query to copy its data into an existing Access table with the field names that I want.  Before the import, I would use a delete query to delete the records in the Access table so that it will be empty before the import.