Afternoon All!



When you bcp something as simple as "select * from MyTable" to a text
file, can you also export the column headings as well. The aim is to
export data but the user, who will import to excel during the day at
some point needs the column headings.



Before you ask, I would normally run a DTS with excel export but I don't
know how to dynamically change the date of the excel file, thus not to
overwrite...



Thanks in advance



Simon


-------------------------------------------------------------
120 years of the MDU: Still the leading choice
-------------------------------------------------------------
MDU Services Limited (MDUSL) is authorised and regulated
by the Financial Services Authority in respect of insurance
mediation activities only. MDUSL is an agent for Zurich
Insurance Company and Converium Insurance (UK) Limited. In
Ireland, MDUSL is a tied agent of Eagle Star Insurance
Company (Ireland) Ltd and is regulated by the Irish Financial
Services Regulatory Authority. MDUSL is an agent for the
Medical Defence Union (the MDU). The MDU is not an
insurance company. The benefits of membership of the MDU
are all discretionary and are subject to the Memorandum and
Articles of Association.

MDU Services Limited Registered in England 03957086.
Registered Office: 230 Blackfriars Road London SE1 8PJ


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

MS Sql Server LazyDBA home page