 |
 |
Archives of the TeradataForum
Message Posted: Wed, 17 Feb 2010 @ 18:59:13 GMT
| Subj: | | Re: Linking to and Querying Access database |
| |
| From: | | Hickman, Andy (A.J.) |
Paul,
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.
Andy Hickman
Enterprise Information Architect - Ford Credit
| |
