Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Import Data with Null Field

Avatar of Matt Hasten
Matt HastenFlag for United States of America asked on
Microsoft SQL Server
2 Comments1 Solution256 ViewsLast Modified:
I apologize for my lack of experience - I come from the network world and I have recently been employed by a company that has an app that runs on top of SQL Server.  I AM the IT department, so the SQL server now belongs to me.  I know enough to be dangerous.

Here's my issue:
I need to import some data from a spreadsheet into a table in the db.  I know the process to do this using the wizard.
The problem - in the table is a field that is labled as not null.  This field is populated 'automatically' when users enter information through the application.
When I try to import my data, I get an error based on the fact that this field cannot be null.
What is the workaround for this?

As a side note:  anyone know of any good resource(s) to get a SQL newbie up to speed?
Avatar of Patrick Matthews
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers