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 |
|
newdbo
Starting Member
2 Posts |
 Posted - 2009-09-03 : 21:15:19
|
| I used DTS to import excel file to sql server, but problem comes when text format from excel to sql server 2000, some text values detected as null in sql server, then i try manually to add single quote in the text row from excel, it looks like fine in sql server. If i want to create code so automatically it will run well, how can i do that?thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-05 : 06:20:26
|
| are you talking about importing from excel csv? |
 |
|
|
|
|
|
DTS inccorect format