All Forums Analytics
Satexasuser 1 post Joined 03/07
22 Mar 2007
Accessing Teradata Data from Microsoft Access Form.

Everyone,Here's what I have: I'm doing a SQL Join where one table is in Teradata and the other is MS ACCESS. I connect using ADO and connect fine to the Teradata database. I actually have the Teradata Table linked. So I go to execute the code and start getting formatting errors about expecting something between "," etc. Is it possbile to join a Teradata Table with say MS Access Table? Surely it must be. I've tried to fully qualify the column names but it really does not like the dbo. etc. So does anyone have any thoughts or done this successfully?MP

sachinp17 53 posts Joined 11/06
23 Mar 2007

Hi, You can't join the two tables like this even though u r using ADO.Regds,sachin

NMadson-3173 44 posts Joined 09/06
13 Apr 2007

Have you tried linking the Teradata table via ODBC?If the Teradata table is large, your query could take quite a while, but for small tables this works.Just curious, how do you link to a Teradata table via ADO?N.

You must sign in to leave a comment.