Suppress Import Data Results Message

[Linda]

And the question...

I am using VBA code to import data from a spreadsheet into a table in Access (2002). All works fine, however I get an Import Data Information message
"(My Application) was unable to append all the data to the table. The contents of fields in (0) records where deleted, and 0 records were lost blah blah blah ....." even when all the data is loaded completely. This is a very long and confusing message to the End User

How can I suppress this message (via code) from popping up after the Import is complete
Thanks
Linda.

 

[Jim/Chris]

DoCmd.SetWarnings False
Code......
DoCmd.SetWarnings True

Jim

-----Original Message-----
And the question....

I am using VBA code to import data from a spreadsheet into

a table in Access (2002). All works fine, however I get an
Import Data Information message:

"(My Application) was unable to append all the data to the

table. The contents of fields in (0) records where
deleted, and 0 records were lost blah blah blah ....."
even when all the data is loaded completely. This is a
very long and confusing message to the End User.

 

[Linda]

Such simplicity!

Thanks.