I am working with vb to perform tasks via ODBC on a Foxpro data table residing in a database container. I am having no luck with putting new data back into the table. SQL statements used to get data out of the table and modify data within the table work fine.
I have placed the data to add to the table in a 2 dim array, however all sql statements just error out, any suggestions as to what is going on here?

What is the Err.Description?
What is the actual statement that raises the error?
Which version of VB are you using?
You need to be our eyes into the situation for anyone to have the slightest hope of being helpful.
You essentially have said, “My car dies when I step on the gas; what's wrong with it?” No one could answer that without some details.