When I export an Access table to a .csv file, it changes the field names replacing the # with a period. For example, the field "Name#1" becomes "Name.1". The application that will be ingesting the output file requires the # instead of the period. How can I either prevent this or rename the column header in the output?
I am using Access 2013.
Per request, here is the code:
Dim strPath As String
strPath = Application.CurrentProject.Path & "\Test"
DoCmd.TransferText acExportDelim, , "Customer_Info", strPath, True