I am importing an Access .mdb file into MS SQL server, and empty fields where the default value is "", change into NULL. This is a problem when I re-export a result set and have to apply a procedure to clean these values. Is there a way to eliminate this? . . . . and what have I missed?Check 'allow nulls' and 'default value' settings in the access tables.|||and to solve for the export problem...
Use a query to export the table, and use
Select ISNULL(yourfield,"") AS FIELD1...sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment