Sorry, I was not sure to post this in the VFP forum or the Office forum, but here it is...

I am using Microsoft Excel VBA and ADO to connect to a VFP6 dbc with stored procedures to calculate the primary keys.

Everything works fine until I try to create a new record through ADO with the recordset.addnew command. I get an error message that says the provider can not do that command.

Does anyone know of a workaround without going to a COM solution? I am not up on the COM learning curve, and would hate to postpone this project until that can happen.

TIA,
Dan Neuman