• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 589
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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