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 |
|
b00gieman
Starting Member
14 Posts |
 Posted - 2007-08-21 : 06:30:47
|
| Hi!I decided to use OPENROWSET for importing data from an excel file into a sql table.When I import the data,I have a problem: -not all the data is imported to my sql table -some values in the sql table are different from the ones in the excel fileFor example,a value that in the excel file is:87878787 will be in the SQL table:8.78788e+007.Can somebody pls tell me what's the problem |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
OPENROWSET