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.
 

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

Importing via TransferSpreadsheet, receiving "type conversion fail 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing Excel spreadsheet 21
Importing Excel Spreadsheet into Access 6
Error in docmd.transferspreadsheet? 11
Excel Access - importing an excel spreadsheet 0
How can I name an imported excel spreadsheet 1
Excel How to Fix Damaged Excel File That Won't Open? 3

Back
Top