MS Access 2010 has changed.
We had an access file that used to be able to export a table to a text file and retain the fixed width of the file, with no formatting MS Acccess 2010 puports to help you, such that if you use the exportwith formatting command, you get a text file, with special headers and field separators, defeating the purpose of a simple export.
What is the best way to export to text from Access 2010 using a Macro...or VB.
In this case, I have a table called header.
I want to create a text file called header.txt with no formatting, but just use the definitiions within the table to provide the output (ie column x is 2 digits wide, etc)....