?
Solved

Issue relating to importing dbf files to SQL 2005

Posted on 2007-10-18
5
Medium Priority
?
245 Views
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.

Thanks.



0
Comment
Question by:sarika_patalay
  • 2
4 Comments
 
LVL 16

Expert Comment

by:SQL_SERVER_DBA
ID: 20103327
0
 

Author Comment

by:sarika_patalay
ID: 20103501
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 !!

0
 

Author Comment

by:sarika_patalay
ID: 20104364
ok, i found the answer :
installing vboledb driver will fix it.

Moderator pls close the question. Thanks.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22529867
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

840 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