Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 18 Jun 2002 @ 16:18:44 GMT

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

Subj:   Re: Microsoft-Access and Teradata
From:   dean pradeep


Following approaches can be taken regards to building reports from MS Access:

1: Using ODBC to connect to Teradata tables (Link table) and write your reports. If there is any aggregations or MS function applied to the data set, then the large set of data will be transferred to the user pc before functionality been applied. This often results in poor performance.

2. Create pass-through query in access using Teradata SQL, this will only bring back the rows that displayed on the report and much of the processing will be done in Teradata. This would be author recommended option.

3. Use ADO record set make snapshot of the data required for report and manipulate the data with vba code for report presentation.

Hope this helps!!!


  <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: 27 Dec 2016