Pull data from query in ODBC Teradata into a table in access

%3CLINGO-SUB%20id%3D%22lingo-sub-418724%22%20slang%3D%22en-US%22%3EPull%20data%20from%20query%20in%20ODBC%20Teradata%20into%20a%20table%20in%20access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-418724%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20get%20data%20from%20a%20query%20executed%20on%20Teradata%20ODBC%20and%20put%20the%20results%20in%20a%20table%20in%20access%20database.%20And%20I%20want%20to%20automate%20this%20as%20well%20(like%20have%20a%20button%20that%20runs%20the%20query%20in%20Teradata%20and%20pulls%20the%20result%20of%20a%20table%20into%20a%20specific%20table%20in%20the%20access%20Database.%26nbsp%3B%20Can%20this%20be%20achieved%20in%20Access%20I%20couldn't%20find%20any%20resources%20online%20for%20the%20same%2C%20please%20point%20me%20in%20the%20right%20direction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-418724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETeradata%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi ,

 

I am trying to get data from a query executed on Teradata ODBC and put the results in a table in access database. And I want to automate this as well (like have a button that runs the query in Teradata and pulls the result of a table into a specific table in the access Database.  Can this be achieved in Access I couldn't find any resources online for the same, please point me in the right direction.

 

Thanks

0 Replies