Solved

Dbase driver for SBS 2008 64bit version

Posted on 2011-03-07
4
568 Views
Last Modified: 2012-05-11
Hi,

I want to know where to find Dbase driver for SBS 2008 - 64bit version. I want to use openrowset command in MS sql to import data from Dbase. I need 64 bit Dbase driver.

Or any other way i can import dbase to sql without using third party program. Thanks
0
Comment
Question by:AungMyat
  • 2
  • 2
4 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35067761
Hi,

I would like to recommend SSIS to you.
Just follow instructions in blog post below:

http://dataintegrity.wordpress.com/2009/10/02/converting-dbf-files/

Takle care,
Daniel
0
 

Author Comment

by:AungMyat
ID: 35117751
I tried it, but i have to change some data types when importing to SQL, especially dbase data format to Sql format. Is there any other way which automates the data type mapping so that i don't need map the data type manually? Thanks
0
 
LVL 14

Assisted Solution

by:Daniel_PL
Daniel_PL earned 500 total points
ID: 35154934
You can write your own code in SSIS or use third party converting tool.
0
 

Author Closing Comment

by:AungMyat
ID: 35340342
Partially correct
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 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

22 Experts available now in Live!

Get 1:1 Help Now