Tag Archive | "export wizard"

Does Anyone Know How To Modify An Existing Export Specification In Microsoft Access 2010?


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

Posted in Affiliate Marketing 101Comments (0)


Archives

Powered by Yahoo! Answers