Re: Importing Excel spreadsheets

You did add the " " around the new excel *** and the path?
Jim Jones wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200711/1

.