Csv output - 10-18-2004 , 06:45 PM
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
Re: Csv output - 10-20-2004 , 02:27 PM
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
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