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 |
|
kkmurthy
Starting Member
41 Posts |
 Posted - 2004-09-16 : 15:35:51
|
| While I am trying to import the data from spread sheet I cam e across 2 problems.1 Some date valus are getting imported as nulls into the date coulmn in the database2 The field width of the desc field is definitely less than 8000 characters. When ever I tried to import that data I am getttting an error that field width is greater than the filed width of the column in the database whcih is Desc varchar (8000). I tries the functins such as left , ltrim rtrim but it is of no use.Please help |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-16 : 15:48:44
|
try exporting the xls to csv and importing csv to sql. see what kind of rouge data there is in CSV...Go with the flow & have fun! Else fight the flow  |
 |
|
|
kkmurthy
Starting Member
41 Posts |
Posted - 2004-09-16 : 16:57:24
|
quote:
Originally posted by spirit1
try exporting the xls to csv and importing csv to sql. see what kind of rouge data there is in CSV...Go with the flow & have fun! Else fight the flow
.Thank you . I will try . |
|
|
|
|
|
|
importing xl spread sheet into sql server database