I have some of the users of my database import excel sheets.
Sometimes when they import an excel sheet they get the following error.
"not all of your data was succesfully imported. Error descriptions that are associate with rows can be found in table..blah blah"
I dont want them to see this error. I know why this error appears. Their are a few cells that are blank when the import the data so it tosses them aside. Does anyone either know what i can do so that the users wont see this message and get scared?
Is their an error code i can capture?
If you need more information, the users import an excel sheet. They let access determine the primary key, all they do is click next next next.
Thanks in advance
Sometimes when they import an excel sheet they get the following error.
"not all of your data was succesfully imported. Error descriptions that are associate with rows can be found in table..blah blah"
I dont want them to see this error. I know why this error appears. Their are a few cells that are blank when the import the data so it tosses them aside. Does anyone either know what i can do so that the users wont see this message and get scared?
Is their an error code i can capture?
If you need more information, the users import an excel sheet. They let access determine the primary key, all they do is click next next next.
Thanks in advance