Importing Excel spreadsheets

[Jim Jones]

I need some help with an error message I don’t understand.

I am using the following expression to inport from an Excel spreadsheet
named BS.xls to a table called BS

DoCmd.TransferSpreadsheet acImport, , "BS", "\a path\BS.xls", True

where 'a path' represents the location of BS.xls on my network

It works fine. Then I use a corresponding expression to inport from another
spreadsheet called DVS.xls, the format of which is intended to be the same.
However, when I attempt to inport from this spreadsheet, I get the following
error message

Run-time error 3709
The search key was not found in any record

I can detect no difference between the 2 speadsheets

Any help would be much appreciated.

Jim Jones

 

[Hoardling via AccessMonster.com]

You did add the " " around the new excel sheet and the path?