Archives of the TeradataForum
Message Posted: Wed, 17 Feb 2010 @ 18:59:13 GMT
Here's a slightly different method to use, if you have administrator rights on the Access database. Within Access, you could link to the Teradata table. To do this, while looking at the Table Objects pane, click the "New" icon on the toolbar, then choose "Link Table", then select "ODBC Databases()" in the FileTypes dropdown. You will then get the ODBC Wizard to connect to Teradata. Make sure to put in the database you want to select from in the "Default Database" box on the Teradata Logon window, so it only searches that database instead of the whole DBC for tables you have access to. Then select the tables you want to connect to from the list.
Once they are connected, they will show up in the Tables Objects pane in Access with a globe icon to show they are Linked Tables. You can reference them just like any other Access table from now on. I normally use Access as the interface at this point, but you should be able to use SQL Assistant against the Access database, if you prefer.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|