Solved

Transfer DBF to MS SQL

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

919 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

16 Experts available now in Live!

Get 1:1 Help Now