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
Categorized | Affiliate Marketing 101
Does Anyone Know How To Modify An Existing Export Specification In Microsoft Access 2010?
Posted on August 23, 2011.
Check out the link below.
There are other ways of course. You can even export and open it as an Excel file by copy to a array.