How about converting to string. Excel is correctly interpreting bit = 0 =
false and that is how it displays the boolean.
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"chris" <chris (AT) noemail (DOT) com> wrote
Quote:
sql2k
sp3
I have a DTS package that shoves the results of a query into Excel. It
converts the 0's in my bit fileds into the word false. How can I stop this
from happening?
TIA, Chris
|
excel converts bit fields to false -
04-16-2004
, 04:12 PM
Linear Mode
