In older versions of Access (2003) there used to be an Advanced button presented during the export wizard that allowed you to select and edit an existing specification. I no longer see this feature in Access 2010. I need to modify the specification to eliminate quotes. The file is being exported as an Excel csv file.
Here is the code on a button:
Private Sub Command124_Click()
DoCmd.TransferText acExportDelim, “DEPTSpecification”, “DEPT_Employees per Dept”, “C:\” & “DEPT-” & Format(Now, “YYYYMMDD”) & “.csv”, True
DoCmd.OpenTable “DEPT_Employees per Dept”
End Sub