Output To text with no headers ?

B

bringmewater

In Access 2007, I have a macro that uses "Output To" to write a text
file. How can I get the macro to export a simple CSV file with NO
headers and just the delimited data (no ----------- line separating
each row).

Thanks

ex:
name, 2342, 432, hello kitty
more, 2111, 332, arf
 
J

Jeanette Cunningham

Hi,
this macro in A2003, exports to a simple CSV file with no headers

You could code your macro

Action: TransferText
Transfer Type: Export Delimited
Specification Name: 'leave this blank
Table Name: 'your table
File Name: 'your path and file name
Has Field Names: No

Jeanette Cunningham
 
B

bringmewater

Thanks but Access 2007 doesn't appear to have a TransferText action in
macros.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer Text, Export Delimited w/ Number formated to 4 decimals. 1
output to text 3
access 2007 output table to csv 2
Export table to txt file with a variable filename 0
Export to CSV no text qualifiers in the header 1
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Output Query Results to a Text File 1
Exporting to text files with macros 3

Top