Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Aug 1999 @ 13:59:22 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Excel spreadsheets
From:   David Roth


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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020