impulse
07-17-2007, 02:21 PM
I importing a database from Access into Microsoft SQL Server 2000. I received some errors for one of my tables while importing it.
Columns strCustSalesRep, strCustCompany, strCustJobTitle status 10, Integrity violation; attempt to insert Null data or data which violates constraints.
I know that there are some blank fields in my database. It was the information i was given to work with. What do I do to import the table? I'm fairly new to SQL. Please explain with great details.
Columns strCustSalesRep, strCustCompany, strCustJobTitle status 10, Integrity violation; attempt to insert Null data or data which violates constraints.
I know that there are some blank fields in my database. It was the information i was given to work with. What do I do to import the table? I'm fairly new to SQL. Please explain with great details.