Importing an Excel spreadsheet gives a 7874

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

Guest

When importing an Excel spreadsheet in to an Access 2003 mde that was
installed using the Access Installation Runtime engine, a 7874 error is
sometimes given (it cannot find the <tablename>_ImportError table). I do not
get this error when testing the mdb in an Access development environment with
the same Excel file that causes the error on the mde. What am I missing in
the runtime engine installation package?
 
First, you should not be importing into an mde, but the problem is when there
is an errror in the import, Access wants to create a new table. Since it is
an mde in runtime, you can't create a new object like that.
 
Back
Top