![]() Now in code you can use this saved specification in the TransferText command as follows:ĭoCmd.TransferText acExportFixed, “Employee Export Specification”, “Employee”, txtExportName Now select Save As, name your specification and click OK. You can see that it fills in the start and length values based on the table definition. For this example I am going to select Fixed Width. Here you will define the format for the file that you wish to create. You are now looking at Export Specification wizard. When the Export Text Wizard opens click Advanced ![]() When the browse box comes up navigate to basically any directory, enter a file name, and choose the Text Files type. When you have created the table or query open it up then select File/Export form the menu bar. Our example is a simple Employee table: Acceess Export Specifications Finding your way to the specifications is one of Access’s more obscure features.įirst create the table or query that you wish to export. Use the export specification wizard to create the specifications for the DoCmd.TransferText macro and visual basic function. You can define a file export format specification, name that specification, and then use it to automate exporting table or query information to a file in specified format. File export specifications are create in MS Access using a wizard.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |