Run Saved Import Or Export Specification. Follow the instructions in the wizard. So Im having a hard time trying to add an extra field to an export using the DoCmdTransferText function in Visual Basic.
To know the true name run the following SQL. Before running the RunSavedImportExport action make sure that the source and destination files exist the source data is ready for importing and that the operation will not accidentally overwrite any data in. On the Task tab in the Microsoft Office Access group click Run Import or Run Export.
Transfer only brings the first 255 characters.
The text file specification My Saved Access Import Spec does not exist. After you click OK or Finish and if Access successfully completes the operation. You can click either of the tabs on the dialog box to switch between the saved import and saved export specifications. On the wizard.