• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 583
  • Last Modified:

Dbase driver for SBS 2008 64bit version

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
AungMyat
Asked:
AungMyat
  • 2
  • 2
2 Solutions
 
Daniel_PLDB Expert/ArchitectCommented:
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
 
AungMyatAuthor Commented:
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
 
Daniel_PLDB Expert/ArchitectCommented:
You can write your own code in SSIS or use third party converting tool.
0
 
AungMyatAuthor Commented:
Partially correct
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now