Issue relating to importing dbf files to SQL 2005

Posted on 2007-10-18
Last Modified: 2013-11-30
Hello Experts,

I am trying to import Fox Pro (dbf files) into a SQL table.

Heres my problem:
I have done this many times on my local system using import - export wizard, by selecting ODBC source for foxpro. Now, when I am trying to do it on my new system, I do not see the 'ODBC Source for Foxpro'  listed. The new system had SQL 2005 installed with service pack 1 and service pack 2. (just like my old one). Whats more, I also have run the VFPODBC driver - Rebooted the system, but I still do not find the Foxpro source.

I will really be greatful to anyone who is willing to help.


Question by:sarika_patalay
    LVL 16

    Expert Comment


    Author Comment

    I checked the link, but it relates to fox pro linked server to SQL issues. I issue is not related to linked servers.

     I am trying to import a foxpro table into SQL uaing SQL2005 import / export wizard. As stated in my previous post, i have done this before using the source component 'Microsoft OLE DB provider for Visual Fox Pro'. Now, in my new system, when I try to do the same (i.e. importing a foxpro table into SQL), I just dont see to find the component ! Albeit installing SP1, SP2 and VFPODBC Diver !!


    Author Comment

    ok, i found the answer :
    installing vboledb driver will fix it.

    Moderator pls close the question. Thanks.
    LVL 1

    Accepted Solution

    PAQed with points refunded (500)

    EE Admin

    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.

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    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

    11 Experts available now in Live!

    Get 1:1 Help Now