Hi Frnds,

I am importing data from excel to access using ASP.
But at the time of importing I am facing some problem. Let me discuss elaborately.
Say I am having one data in excel sheet. After inserting the data into database an error is occurring, saying, “Primary index cannot be null”.
I can understand that the error is occurring due to the next field in excel sheet, which is NULL. Can I restrict this error by someway?

Anybody please help me.

Prasanta

The only way you can restrict the error is by dropping your Primary Key definitions on your columns and then you can insert NULL data at will.

This is a design flaw though, because if you have an index the data should NEVER be null. Anyway, dropping the keys will allow you to insert the data.

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.