I'm using DoCmd.RunSavedImportExport to import a text file to a table in my db
The table has fieldnames Field1, Field2 etc.
I think this command will change them
CurrentDb.TableDefs("TableName").Fields("FieldName ").Name = "NewName"
but it would be repeated many times.
I do have a empty "tblTemp" (structure only) with the fieldnames. Is there a way to copy them into the new table ?