Importing from Excel using DoCmd.TransferSpreadsheet

  • Thread starter Thread starter David Cleave
  • Start date Start date
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
 
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
 
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.
 
Back
Top