J
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
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