Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data changes to Scientific Notation upon importing into table

Status
Not open for further replies.
SimeonJ

SimeonJ

IS-IT--Management
Jun 7, 2006
10
US
All,

When I'm importing some data into a table, the values in some places are being changed to scientific notation. I'm unable to use the data that is changed to scientific notation. Does anyone know why this is happening? How can i stop this from happening? Thanks in advance!

Simeon
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
244
markjoseph1232
markjoseph1232
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
124
botatun
botatun
MICKI0220
  • Locked
  • Question
Overflow problem when importing to sql 2008
Replies
2
Views
104
drlex
drlex
MICKI0220
  • Locked
  • Question
Overflow problem when importing to sql 2008
Replies
0
Views
61
MICKI0220
MICKI0220
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
145
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top