Solved

Transfer DBF to MS SQL

Posted on 2014-12-24
2
111 Views
Last Modified: 2016-02-18
Dear Sirs,
What tool can you recommend to transfer data from dbase (dbf) to MS SQL.
I am looking at more than 100 Dbf tables.
Looking forward to hearing from you.
0
Comment
Question by:Omer-Pitou
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 40517614
You can use SSIS.

See these questions and solutions
Can I use SSIS to import dbf files with changing column counts
http://www.experts-exchange.com/Database/MS-SQL-Server/Q_24848595.html

http://www.experts-exchange.com/Database/MS-SQL-Server/Q_28462724.html

mlmcc
0
 
LVL 37

Accepted Solution

by:
PatHartman earned 250 total points
ID: 40519062
This is a product I used to convert FoxPro to SQL Server.  It has other conversion options also.  There are customization options that let you alter column names and formats as necessary.

https://www.spectralcore.com/fullconvert/howto/dbase-to-access
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

739 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