Hi!
I have a problem importing data from excel into a table in a MS SQL Server 2000 database. What happens is I define the connections between excel columns and database columns and leave my identity column and a column that has a default value as <ignore>. When I execute this I get an error message telling me I'm either trying to insert invalid data or NULL data in a column that does not allow NULL data (which neither column does). I have, after searching here, tried unchecking "Enable identity insert" but it makes no difference and also that wouldn't explain the default issue. Could there be some database setting that I've overlooked?
Any help would be greatly appreciated!
Thanks in advance,
/Chris
I have a problem importing data from excel into a table in a MS SQL Server 2000 database. What happens is I define the connections between excel columns and database columns and leave my identity column and a column that has a default value as <ignore>. When I execute this I get an error message telling me I'm either trying to insert invalid data or NULL data in a column that does not allow NULL data (which neither column does). I have, after searching here, tried unchecking "Enable identity insert" but it makes no difference and also that wouldn't explain the default issue. Could there be some database setting that I've overlooked?
Any help would be greatly appreciated!
Thanks in advance,
/Chris