asked on

Issue relating to importing dbf files to SQL 2005

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.

Thanks.

SQL_SERVER_DBA

have you looked at this]
http://support.microsoft.com/kb/908915/en-us?spid=2855&sid=global

sarika_patalay

ASKER

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 !!

sarika_patalay

ASKER

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

Moderator pls close the question. Thanks.

ASKER CERTIFIED SOLUTION

Computer101

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial