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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Openrowset problem

Author  Topic 

b00gieman
Starting Member

14 Posts

Posted - 2007-08-22 : 04:00:38
Hi!
I have a problem with the openrowset function.I'm importing data from an excel file into a sql table.A value taht in the excel file is like 87987845 will appear into the sql table like 8.79878e+007.Can somebody tell me what's causing the data to be written exponentially into the sql table ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-22 : 04:21:43
Why are you CROSS POSTING? You already have got an answer here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88141



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

b00gieman
Starting Member

14 Posts

Posted - 2007-08-22 : 10:00:41
Sorry
Go to Top of Page
   

- Advertisement -