If I export out a table to a (Text) output file called xxxx.csv and some of
the fields are defined dec(13,2). If you open this file in Xcel will that
formatting still hold over or will it resort to a text output field.


How can I make those fields keep the 13,2 decimal formatting.


any thoughts ... I want to keep the csv output file not create an Xcel
file.

csv is not Excel. csv files have Excel associated with the extension so it
looks as though it is Excel opening them.

I can see no reason why with formatting that the field should lose precision
or scale.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"AHartman" <Hoosbruin (AT) Kconline (DOT) com> wrote