Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Location
    Manila Philippines
    Posts
    5

    Unanswered: Using MS Access to extract data from Oracle DBEE 9i

    hi all. i'm just an ignorant oracle sales rep trying to make sense of my client's technical issues. Feel free to enlighten me on this one. My client is using MS Access to extract data from their financial application called APPGEN. The client is planning to move to Oracle Ebusiness suite 11.5.10 (soon i hope). The client wants to know if they can use their MS Access to extract data from the Oracle DB 9i backend (similar to Discoverer functionality i think). Has anybody tried doing this? any reply is greatly appreciated.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Perhaps try this:

    Code:
    Dim conn As ADODB.Connection
    Dim rs As ADODB.Recordset
    Dim txt As String
    Dim fld As Field
        ' Open a connection using Oracle ODBC.
        Set conn = New ADODB.Connection
        conn.ConnectionString = "Driver={Microsoft ODBC for Oracle};" & _
            "UID=userName;PWD=userPasssword"  ' "UID=;PWD=" if none (??)
        conn.Open
     
        ' Open the desired table.
        Set rs = New ADODB.Recordset
        rs.Open "yourOracleTableName", conn, adOpenDynamic, adLockOptimistic, adCmdTable
     
        ' List the data.
        Do While Not rs.EOF
            txt = ""
            For Each fld In rs.Fields
                txt = txt & Trim$(fld.Value) & ", "
            Next fld
            If Len(txt) > 0 Then txt = Left$(txt, Len(txt) - 2)
            ' do what you want with data here...
            ' Perhaps put into a ListBox:
            ' List1.AddItem txt
            rs.MoveNext
        Loop
     
        ' Close the recordset and connection.
        rs.Close
        conn.Close
    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •