Archives of the TeradataForum

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

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

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>>