I had this issue before and just can't remember how I resolved it.
I have a very simple table and I just want to transfer it to a text file that is tab delimited and include the headers. I've tried both a macro and vba and am using a specificaiton. If I don't use the specification, the headers are transfered, but, of course, it's a coma separated file.
I made a test database and attached.