Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set export defaults (CSV)

Status
Not open for further replies.

MasterRacker

New member
Oct 13, 1999
3,343
US
Does anyone know a way to set Access 2003 to include headers when exporting to CSV? (Defaulting the file extension to CSV instead of TXT would be helpful as well.) Thanks.

_____
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]
 
Have a look at DoCmd.TransferText. It allows you to specify the name of the file and to specify whether or not headers are included.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top