Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 17 Feb 2010 @ 18:59:13 GMT

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

Subj:   Re: Linking to and Querying Access database
From:   Hickman, Andy (A.J.)


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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023