I am trying to export a table to a txt file using only VBA. Whereas I have managed to do this I am having problems getting the field formats I want (again using only VBA). When I use the TransferText command I know I can call a specification name, does anyone know how to create their own specifications to call up in code? 
