Error while inserting null data in Append Query

S

subbu

Hi,
I am using the append query to insert data.I am getting
error if one of the values is null.How to handle nulls
while using the append query

regds
subbu
 
J

John Vinson

Hi,
I am using the append query to insert data.I am getting
error if one of the values is null.How to handle nulls
while using the append query

regds
subbu

You can't append NULL into a Required field. If that's not the issue,
please post the SQL of the query and the error message that you're
getting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top