Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-418709%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-418709%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-418709%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
sqlfanatic
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies