I am trying to automate the exporting of some data from a Table to a Test File. The data is actually created by a Query, but because I have some Memo fields of more than 255 characters, I have had to make the Query an Append Query, & my code firstly removes all Rows from the Table, then runs the Query to repopulate the Table.
If I Export the data from this Table manually, it works just fine, using the Export Specification I have created previously. However, if I run my VBA Code, I get the following error:
"Run-time error '3442':
In the text file specification 'ExportToTextFile', the ExtendedInfoText option is invalid."
Here is my VBA Code:
DoCmd.TransferText acExport, "ExportToTextFile", "ExportToTextFile", "\\Ukenetsrv01\clients\Direct.com\Export.txt", True
The ExportToTextFile is the Export Specification I have previously created.
Any idea what's wrong here?