OLE DB setup.  Where do I start?

Posted on 2005-04-14
Last Modified: 2011-09-20
I have an some dbf tables (VB 5 I think) that are a part of a custom written application.  I need to be able to setup a live connection between the dbf file and MS Outlook so I can view names and addresses and possibly edit some of the data in the fields.  The tables will need to be acessible from Outlook and my custom app at the same time.  The primary purpose is to view the data and not modify it.  Where do I start?  Is this going to be complicated?  
Question by:pauljnye
    1 Comment
    LVL 2

    Accepted Solution

    Firstly DBF files are dBase (III, V, etc) format database files and can be connected to using several methods like a DSN or using Microsoft Jet E.g

      Dim Conn: Set Conn = CreateObject("ADODB.Connection")
      Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                       "Data Source=" & Path & ";" & _
                       "Extended Properties=""DBASE III;"";"
      Set OpenDBFConn = Conn

    The best way will be for you to write an add-in to Outlook which will allow you to view the dbf files from within Outlook. I would use VB.NET or C#.  This is not that complicated and is very similar to wirting a standalone application and most of the code (database access code) will be the exact same in your Outlook app and in your standalone app.

    Could you give some more information about the evnironment, what IDE you are using if any?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    Title # Comments Views Activity
    Reading variable length EBCDIC in SAS 9 56
    dividesSelf challange 15 57
    countHi challenge 25 59
    array11 challenge 16 40
    This article will show, step by step, how to integrate R code into a R Sweave document
    A short article about a problem I had getting the GPS LocationListener working.
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now