Re: column formatting without exponents

#1

Hello BillyRogers,

Where do you see the 4.30915090000993E+15?

Is it in a client tool? Is it XL?

What does Query Analyser say?

This looks to be a feature of the client not the way the data is stored

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

I'm trying to move data from an excel spreadsheet that has column like
this

ACCOUNT
4309150900009930
4305940023804320
Into a table. The number ends up looking like this.
4.30915090000993E+15

I'm new at using DTS so I may be overlooking something obvious. the
field type is nvarchar(255). How do I keep it from using an exponent?

Thanks

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: column formatting without exponents

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: column formatting without exponents - 12-03-2006 , 03:32 AM