Accessing Teradata Data from Microsoft Access Form.

Analytics

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
2 REPLIES
Enthusiast

Re: Accessing Teradata Data from Microsoft Access Form.

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

Regds,
sachin
Enthusiast

Re: Accessing Teradata Data from Microsoft Access Form.

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.