Solved

Transfer DBF to MS SQL

Posted on 2014-12-24
2
93 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
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 34

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

708 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

17 Experts available now in Live!

Get 1:1 Help Now