Importing from Excel using DoCmd.TransferSpreadsheet

D

David Cleave

Hi all

When this command runs, everything stops and I get the
following error:

Run-Time error 3275

Unexpected error from external database driver (22).

I'm trying to import data from an Excel 5.0 workbook (not
that it makes any difference if I update it to 7).

The full command is:

DoCmd.TransferSpreadsheet acImport,
acSpreadsheetTypeExcel5, "PWA Employees for
Update", "G:\Training\all employees update from pwa to
tim.xls", True

Anyone got any good ideas what this is about?

Cheers

David
 
G

Guest

I should point out the specific error I'm getting is:

Unexpected error from external database driver (22).

There's nothing at all about this on the web. Why do I
always get the beauties?

David
 
K

Ken Snell

Likely the error is caused by the length of the filename and/or the combined
path and filename.

Try renaming the file to an 8-character file name and try it.
 

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

Top