I recently upgraded to Access 2010 at work and had to open one of my old databases to run some macros. This database had been built in Access 2003 and was now being open in Access 2010. For the most part, I was expecting all queries and macros to work , and must say they did, except for one in particular: The ImportExportText macro. This macro was exporting text to an excel workbook and while it ran it came up with the following error message: “The text file specification ‘|’ does not exist”… To resolve this, head over to the KB Article ID: 2581495.

Here is what worked for me:

  1. I applied the June 2011 cumulative update for Microsoft Access 2010 – http://support.microsoft.com/kb/2544022
  2. I edited the macro in design view and re-selected the proper text specification.
  3. Saved the macro.

Make sure you do step 2 & 3 otherwise you will continue to get the error. After the update you will see the text specification has changed to a number, like 1 or another ramdom number. You must change it back to the correct one, which in my case was: <name of the macro> import specification.

Hope this helps.