The request for procedure 'tblMyTable' failed because 'tblMyTable' is a table object

Question

I have an excel workbook that uploads data into a sql database. The code has been working fine for the past year.

However today I am seeing the error message below. As far as I can tell nothing has changed.

The request for procedure 'tblMyTable' failed because 'tblMyTable' is a table object 

The second line below is where the error occurs.

Dim rs As New ADODB.Recordset
rs.Open "tblMyTable", pCn, adOpenKeyset, adLockOptimistic

Why is this no longer working?

Answer 1

Check to make sure the stored procedure still exists. Then also check to make sure a table wasn't created with the same name as your stored procedure. Common practice would be to name the stored procedure as "procMyTable." Hope this helps someone else