Archives of the TeradataForum
Message Posted: Tue, 03 Aug 1999 @ 13:59:22 GMT
Depending on the version of excel, you have a couple of options, but we usually just did a small vba script to run the update query directly within excel, moving the data directly from the sheet to the db via an odbc connection. We put the code behind a button that the user presses to update the db.
I like the ms access option mentioed also, but it does require another program like the previous solutions.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|