Export to text error: Microsoft was unable to append all the data to the table
Posted on 2007-08-08
I am exporting a access table with around 90 columns and they are all in text format with a field size of 255. The export to text is in vba code: DoCmd.TransferText acExportDelim, "Qry_toExport Export Specification", "Qry_toExport", filenamepath. My spec file is all text also, with all the same column names. When I do export I receive the error message: "Microsoft was unable to append all the data to the table"
I click yes to proceed anyway and then it exports it and upon further review I do not see anything wrong with the text file. All seems accruate, but I am rolling out db to other users and I need to get rid of that error message. your help is much appreciated.