Hi folks, my first post.
I've had a nightmare trying to do the same thing in Access 2003, so I've writing to a CSV using FSO, writing the table headers in manually
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("c:\" & Format(Now, "mmmyy") & "_" &...