# How to take a query using oracle and store in a MS access table **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [January 16, 2018, 10:31am UTC](https://forums.toadworld.com/t/how-to-take-a-query-using-oracle-and-store-in-a-ms-access-table/40468 "2018-01-16T10:31:56Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![ig2387](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/ig2387/32/12067_2.png) [@ig2387](https://forums.toadworld.com/u/ig2387)\ **Post date:** [January 16, 2018, 10:31am UTC](https://forums.toadworld.com/t/how-to-take-a-query-using-oracle-and-store-in-a-ms-access-table/40468/1 "2018-01-16T10:31:56Z")
What I’m trying to do is take records out of an oracle database and store in a MS Access table using Toad Data Point. 1. I have the Microsoft Access connection. 2 I have the Oracle connection. I need to connect the two together and merge the Oracle data into the Access table. ---
**Author:** ![tm3561](https://avatars.discourse-cdn.com/v4/letter/t/e8c25b/32.png) [@tm3561](https://forums.toadworld.com/u/tm3561)\ **Post date:** [January 22, 2018, 10:10am UTC](https://forums.toadworld.com/t/how-to-take-a-query-using-oracle-and-store-in-a-ms-access-table/40468/2 "2018-01-22T10:10:15Z")
Couple of ways to do this, 1. take a look and see if Access is able to connect to your oracle DB via ODBC and create an import query in access. 2. In TOAD Create your oracle query and then use export wizard to save output to text file and then link or import MS Access to the text file ---
**Author:** ![ig2387](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/ig2387/32/12067_2.png) [@ig2387](https://forums.toadworld.com/u/ig2387)\ **Post date:** [January 26, 2018, 7:21am UTC](https://forums.toadworld.com/t/how-to-take-a-query-using-oracle-and-store-in-a-ms-access-table/40468/3 "2018-01-26T07:21:14Z")
My Access connection is work now. Thanks for your help.