Solved

Dbase driver for SBS 2008 64bit version

Posted on 2011-03-07
4
567 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.

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

12 Experts available now in Live!

Get 1:1 Help Now