Suppress Import Data Results Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
Click to expand...
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
Click to expand...
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.
 
Back
Top