convert all field names to lower case before exporting to excel

[stalk]

Is there a way to convert all the field names to lower case before exporting or saving in the existing Access table?


My data will be feeding another application where it only accepts lowercase variable names.

Thank you

[orange]

see this thread for an example of similar ---change Case of FieldName(s) in table

[stalk]

Code referred in the above link worked perfectly to convert all the fields in a fraction of a second to lowercase with minor change..
fld.Name = StrConv(fld.Name, 2)

1 is to convert to Uppercase
2 is to convert to lowercase
3 is to convert to Propercase.

Thank you