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
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
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