Archives of the TeradataForum
Message Posted: Fri, 10 Jan 2003 @ 14:02:29 GMT
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?
John Balchunas, DBA
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|