A follow-up to my original posting:

1. Here is the connection string I am using:

(note that since for testing I am hardwiring this in the code, I have included escape sequences for the embedded quote characters).

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Program Development\\FootAnalNovel\\Data\\XL Database\\FOOTANALNOVEL-WoundDB.xls;Extended Properties=\"Excel 8.0;HDR=Yes\"";

2. I modified my program so that it doesn't fill the first two data tables from the two worksheets. That means that I don't actually use those two sheets at all. The program still appends a record to the third sheet. I get the same corruption of the three sheets that I described in the initial posting.

3. When I originally posted this, the names of the sheets and the names of the Excel regions were the same. I went back and renamed the sheets with different names than the regions defined on them. The regions still have their original names. The program is using the names on the regions. When I run the program I observed the same corruption of all three sheets that I described in my initial posting.

Thanks again for any help.

Jim