I currently have a small MS Access application that allows the users to import data from text files, run reports or other functions on the data, and then export the data back to a text file for archiving purposes. However I am running into problems when the user tries to export a large table (over 80,000 rows) into a fixed width table using the TransferText method. My code is as follows:
[highlight]DoCmd.TransferText acExportFixed, strExportSpec, strTable, "C:\ExportTest.txt", False[/highlight]
The code works just fine with smaller tables but fails with larger ones.
Does anyone know how to expand the limit of this method - or - know of another method that still allows for an export specification? This one has me stumped; any help is appreciated.
[highlight]DoCmd.TransferText acExportFixed, strExportSpec, strTable, "C:\ExportTest.txt", False[/highlight]
The code works just fine with smaller tables but fails with larger ones.
Does anyone know how to expand the limit of this method - or - know of another method that still allows for an export specification? This one has me stumped; any help is appreciated.