This code uses a FileSystemObject to create, delete and test for Folder and File existence. Part of the project will be to open the CSV file in Excel once it has been generated, so click Tools, References and add the Microsoft Excel Object Library to the project.Īdd the code to the command button in the Access form created. Click OK to continue and then OK in the Export Specification box.Ĭontinue clicking Next until the last pane. Click OK.Ĭlick on the Advanced button in the next pane.Ĭlick on the Save As button to name the SpecificationĬhange the name of the Specification in the box or leave it. Type in the path to the location of the csv file and do not select any other options. To begin generating the Export Spec, right click on the table, in this case: vw_employees, select Export and select Text File. Creating the MS Access Export Specification - Delimited Option The form that this article uses has a single command button that will generate the file. ![]() This article will start with the creation of the Export Spec. However, there have been times when I have gotten an error for not putting a specification name in the command.
0 Comments
Leave a Reply. |