How do I export in MS Access 2007 WITHOUT formatting and layout
Posted on 2009-02-15
I have a query in MS Access that contains a data subset of a table (some data is filtered out). I need to export the data in one step to a CSV/txt file. WHen I choose "export text file" the option to export with Formatting and Layout is selected, and also read-only, so I can't disable it.
that makes the exported file useless,since it has hundreds of horizontal and verticle lines (made of characters).
How do I disable this feature and export a standard CSV from the query?
I need to this be as automated as possible. SO while I could export to excel and then save my excel file as a CSV, I would prefer to do this in one automated step.