Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Issue with switching from jet to ace oledb provider
0 views
Skip to first unread message
tas
Nov 5, 2009, 8:52:02 AM11/5/09
to
For quite some time I've been using oledb jet provider to insert/write data
to excel 2003. I've attempted to switch that connection over to oledb ace
provider to insert/write to excel 2007 .xlsm macro enabled workbook. I don't
have any issue with the provider as long as I only try to insert a few
hunderd rows. However, when I try to insert all the rows I need I don't get
any error in the try catch, but I don't get any rows inserted into the
workbook. In debug I can see the rows being inserted without error, but the
resulting workbook has no rows. I'm assuming I need to make a registry change
or something of the nature. Please advise. Thanks!
to excel 2003. I've attempted to switch that connection over to oledb ace
provider to insert/write to excel 2007 .xlsm macro enabled workbook. I don't
have any issue with the provider as long as I only try to insert a few
hunderd rows. However, when I try to insert all the rows I need I don't get
any error in the try catch, but I don't get any rows inserted into the
workbook. In debug I can see the rows being inserted without error, but the
resulting workbook has no rows. I'm assuming I need to make a registry change
or something of the nature. Please advise. Thanks!
0 new messages