exporting to dbf

Hi,
I am not sure if this problem has been discussed already, if it has could someone please point me in the right direction. The problem I am having is exporting a sql server table to a dbf file. I am having a problem with one field in particular. The fie
ld is defined at a numeric with precision 20 and scale 6. When I export this to a dbf file it cuts of the 6th digit after the decimal. I have tried changing the field type within the transform settings, I have tried changing the type within the table
to such things as float and decimal, but nothing seems to work. I also need this in a dbf format to join up to a GIS shapefile. Does any one have any suggestions of how to get around this?
Message posted via http://www.sqlmonster.com
Create a view that converts the numeric value to a character string. Export
through the view.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sean Lamberson via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:fb57cfae91194086b2c4550e003d9097@.SQLMonster.c om...
> Hi,
> I am not sure if this problem has been discussed already, if it has could
someone please point me in the right direction. The problem I am having is
exporting a sql server table to a dbf file. I am having a problem with one
field in particular. The field is defined at a numeric with precision 20
and scale 6. When I export this to a dbf file it cuts of the 6th digit
after the decimal. I have tried changing the field type within the
transform settings, I have tried changing the type within the table to such
things as float and decimal, but nothing seems to work. I also need this in
a dbf format to join up to a GIS shapefile. Does any one have any
suggestions of how to get around this?
> --
> Message posted via http://www.sqlmonster.com