- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Certainly when you execute an ODBC connection to the SS it is opening that spread sheet and the connection will keep the sheet open until you close it or the user closes the form. After you retrieve your data you will want to call the Close method
xfa.sourceSet.DataConnection.close()
Other than that I do not know enough about how Excel supports ODBC connections to suggest what settins in the data string should be set.
Paul
Views
Replies
0 Likes
Total Likes