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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-29 : 21:37:19
|
| Gelap writes "I use MS SQL 7.0 - DTS Import Wizard to transfer data from Excel to SQL server. The Excel file consist of Name, UserId, etc. Here are example of UserID which I use:7890, 0067, k2350, 9877, k8899The problem with this data transferring is, it does not capture the userIds which have character in it (in this case k2350 & k8899) and it return null values. For numbered userID it will return the exact value from the source file (Excel). I had checked the table design and the datatype for the userID is varchar. Basically, the DTS for the file transferring is a very simple procedure and yet I couldn't find what the problem is. Can you help???? I really appreciate your advice." |
|
|
|
|
|
DTS return null value