How can I automate copying Teradata tables to MS Access?

Tools & Utilities

How can I automate copying Teradata tables to MS Access?

I currently use SQL Assistant to write Teradata tables to existing MS Access tables by using the SQL Assistant "Export Results" File option. The problem is that I must manually direct the output to the specific table in SQL Assistant and there are 30 tables that I need to reload each month.

Is there someway to automate this monthly table reload to MS Access? 

2 REPLIES
Enthusiast

Re: How can I automate copying Teradata tables to MS Access?

One way could be to use ODBC Link Tables in MS Access MDB file.

Link Teradata tables in MS Access

Create a query in MS Access for Insert/Select using Teradata table as sources and MS Access Table as target. Test it, if it works as you want. Just create similar queries for all desire tables to double click once every month

You can also then write a VBA routien to execute all 30 queries in a particular sequence. In that case you would just need to run that VBA routien once in a month and all 30 tables will be populated.

Let me know if it is not clear.

Teradata Employee

Re: How can I automate copying Teradata tables to MS Access?

You can use Teradata OLE DB Access Module (OleLoad GUI) to automate coying Teradata to MS Access.