After the file is successfully uploaded I want to take the rows in the REGION tab and insert them into an MS Access 2007 table.
This may be a limitation of the provider, or of the selected locktype.
Recordset error '800a0cb3' Current Recordset does not support updating.
Open "select master.isbn,master.location from master where isbn = '" & rs MSsb("ISBN").
Value & "'", cn Ebility, ad Open Dynamic, ad Lock Optimistic, ad Cmd Text Msg Box rs EBMaster("ISBN").
It would be better to use a set-based approach so you import all the worksheet rows as a single operation.