Results 1 to 2 of 2

Thread: connect to an Oracle Database thru VBA

  1. 06-24-2003, 09:28 AM #1
    sushilp
    sushilp is offline Registered User
    Join Date
    Jun 2003
    Posts
    2

    connect to an Oracle Database thru VBA

    How should i connect to an Oracle Database thru VBA

    I need to
    a)insert data from an access table into an Oracle table
    b)Update data into an Oracle table from an access table
    Reply With Quote Reply With Quote
  2. 06-24-2003, 09:59 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    u need a ODBC DSN connection to oracle for that and you can connect to oracle though external link tables
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules