Importing Excel spreadsheets

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

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

DoCmd.TransferSpread*** 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
spread*** called DVS.xls, the format of which is intended to be the same.
However, when I attempt to inport from this spread***, 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

.

Quantcast