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 |
|
kbearhome
Starting Member
36 Posts |
 Posted - 2005-12-09 : 12:23:27
|
| I'm using DTS to import from Access. The SQL tables do not allow nulls. How to I prepare the Access fields so they will import even when they don't contain data?Thank you |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2005-12-09 : 14:20:03
|
| 1. Did u try using a query?2. If the problem is the Null in Access different from that in MS SQL Server, did u try ISNULL()function. eg. Select ISNULL(a,Null), ISNULL(b,Null) from Tbl |
 |
|
|
kbearhome
Starting Member
36 Posts |
Posted - 2005-12-09 : 16:01:26
|
| I did not try that. Thanks. |
|
|
|
kbearhome
Starting Member
36 Posts |
Posted - 2005-12-09 : 16:41:25
|
| I've tried using this in the DTS wizard query isnull(`Company`.`vchAssignedId`, ' ' )and this way isnull(`Company`.`vchAssignedId`,null )I get error "Wrong number of arguments" error. What am I doing wrong? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-10 : 02:47:07
|
| Instead of Isnull use COALESCEMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Null values from Access