Results 1 to 4 of 4
  1. #1
    ezeanya is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2016
    Posts
    9

    Retrieve data in a recordset into a table created in access 2010

    I'm new to programming. I want to connect to a secured database and display some fields from a table in the secured database into an existing table in my access.



    i have this so far but I just cannot figure out how to put this into a table called "MyTable"

    Sub RetrieveRecord()


    Dim SQL As String


    Dim Conn As New ADODB.Connection
    Dim mrs As New ADODB.Recordset


    Dim DBPath As String, sconnect As String






    sconnect = "Provider=MSDAORA;Password=;User ID=;Data Source="


    Conn.Open sconnect

    SQL = "select ABC, DEF, GHI from XXX"



    Conn.Execute SQL


    Set Conn = Nothing


    End Sub

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Have you discussed your requirements with your Oracle DBA?
    Organizations have secured databases to prevent unauthorized access to their data.

    Good luck.

  3. #3
    ezeanya is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2016
    Posts
    9
    Yes I did. I can actually connect to the Oracle DBA. everything works perfectly when I connect. my only hiccup is how to paste that into my own access

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    My reference to Oracle DBA is the technical person who is responsible for the design and operations of the Oracle database you are trying to link to.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-29-2015, 09:21 AM
  2. Replies: 22
    Last Post: 01-23-2014, 02:13 PM
  3. Replies: 3
    Last Post: 10-31-2013, 02:36 PM
  4. newbie needs dynamic query created in access 2010
    By hairlesshippy in forum Queries
    Replies: 1
    Last Post: 09-10-2012, 08:55 AM
  5. Replies: 1
    Last Post: 03-09-2012, 07:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums