Solved

Convert DBaseIII to SQL 2012

Posted on 2013-10-26
2
521 Views
Last Modified: 2013-10-26
I am looking for a good, simple database conversion from DBaseIII to SQL 2012. What I need is to bring in DBF and edit the import. I would then export to SQL or EXCEL. I have looked on line for a program but a lot of them are bogus.

Can anyone point me to a good program that will work?
0
Comment
Question by:Dennis Pillow
[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 3

Accepted Solution

by:
netmaster1355 earned 150 total points
ID: 39602577
Maybe the following article help you.
http://technet.microsoft.com/en-us/library/aa337084.aspx


You can connect to a dBASE or other .DBF database file in an Integration Services package by using an OLE DB connection manager and selecting the Microsoft OLE DB Provider for Jet 4.0.
Note Note

The SQL Server Import and Export Wizard in SQL Server does not support importing from, or exporting to, dBASE or other DBF files. You can use Microsoft Access or Microsoft Excel to import the data from DBF files into an Access database or Excel spreadsheets, and then use the SQL Server Import and Export Wizard.
To configure a connection manager to connect to a dBASE or other DBF file

    Add a new OLE DB connection manager to the package. For more information, see Add, Delete, or Share a Connection Manager in a Package.

    On the Connection page of the Connection Manager dialog box, select Native OLE DB\Microsoft Jet 4.0 OLE DB Provider as the Provider.

    When working with DBF files, the folder represents the database, and the individual DBF files represent tables. Therefore the Database file name text box must contain the path of the folder where the DBF file resides, and must not include the file name itself. You can type or paste in a folder path, or you can use the Browse button to select your DBF file, and then remove the file name from the end of the folder path.

    On the All page of the Connection Manager dialog box, enter dBASE III, dBASE IV, or dBASE 5.0, as appropriate, as the value of Extended Properties.

    Click Test Connection to validate the values that you have entered. You should see the message, "Test connection succeeded." Click OK to close the message box.

    Click OK to save the configuration for the connection manager.

    To use your connection manager in the data flow of the package, select an OLE DB source or destination and configure it to use the connection manager that you created by using the preceding steps.
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 150 total points
ID: 39602989
Take a look at DBF Viewer Plus http://www.alexnolan.net/software/dbf.htm .  I have used his MDBPlus program and it worked well.
0

Featured Post

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

691 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