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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-07-01 : 10:43:10
|
| I am exporting data from .xls file into a table in sql server 2000 using DTS. The first column is set to text in excel but the dts doe snot recognise it. It thinks it is integer and that is why it only exports the numbers and not the fileds with text in them??Thanks |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-01 : 10:49:55
|
| do not use the wizard. use the designer. create your table first and explicitly map the columns on the import.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2005-07-01 : 10:53:22
|
| yes, this is indeed what I am doing. But during the mapping it only picks up the number values and not the string values ??Thanks |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2005-07-01 : 11:07:30
|
| Thanks, BUT have to get the DTS job to work. |
|
|
|
|
|
|
dts .xls file