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 |
|
uri dimant
Starting Member
16 Posts |
 Posted - 2002-02-25 : 00:37:05
|
| Hello.we are using sql7.nt4i have excel file whit below structure1 252 test4 305 26 test1when i create package to transfer this file to sqlserverwith below structurecol1 smallintcol2 varchar(20) allow null i get in sql1 252 null4 305 26 nullwhy?,any ideas pleasei have changed datatype of excel column to text but it still doesn't work.also i have tryed to write first row in excel file like 'test' i thouth may be sql does recognaze first row(in my example 2) like numeric and try to insert it as numeric.it doesn't work too |
|
|
|
|
|
dts question (from excel to sql 7)