Importing an Excel spreadsheet gives a 7874

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Subscript out of range when importing into access 2010 from excel 0
Excel Access - importing an excel spreadsheet 0
Importing Excel spreadsheet 21
Importing Excel Spreadsheet into Access 6
Importing Excel Spreadsheet 1
Importing spreadsheet cells that have multiple values 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
change excel spreadsheet before importing 1

Top