Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2002-08-23 : 14:40:34
|
| Hell all..I have a table that I imported from Excel that contains a list of numbers like so:243527533791|220190922|Confirm||Optional Note 243527656126|220306845|Confirm||Optional Note 243527730101|220771045|Confirm||Optional Note But when I import this into SQL the first two columns show up in Scientific Notation like so:2.43527836555E+112.43527836555E+112.43527836555E+11Any ideas on how to correct this?thank you... |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-23 : 15:02:51
|
| What are the data types of the fields you are importing that data into? |
 |
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2002-08-23 : 15:07:24
|
| I just wrote a small script that changes the datatype to bigint from float and that took care of it.thanks anyways. |
|
|
|
|
|
|
Numbers are displayed in Scientific Notation