Avatar

Level 10

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