Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Jan 2003 @ 14:02:29 GMT


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


Subj:   VB for Applications to SQL Converer
 
From:   Balchunas, John

Hi All,

We have a 9-page "VB for Applications" application that runs in Access 2000 (Office 2000) and pulls data from Teradata using ODBC. It massages data based on date manipulation and then creates an MS Access report that is printed to hard copy on a workstation. It takes about 15-20 minutes to run, mostly network intensive.

We would like to convert the VB for Applications code into SQL and build a summary table on Teradata running the SQL in batch overnight. It would probably run in less than 30 seconds and permit wider distribution over the internet or directly to our customers via ODBC connects.

Does anyone know of a converter that will translate the VB code into SQL?


Thanks,

John Balchunas, DBA
Jefferson County Public Schools
Louisville, KY



     
  <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