All Forums Tools
karl_hughes 1 post Joined 03/13
26 Mar 2013
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? 

Karl Hughes
Kawish_Siddiqui 37 posts Joined 03/07
26 Mar 2013

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.

Kawish Siddiqui -

SuSeSi 61 posts Joined 10/08
29 Mar 2013

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

-Sudhansu

You must sign in to leave a comment.