Solved

How to import/Export .DBF into/From SQL Server 2005?

Posted on 2007-03-28
9
5,273 Views
Last Modified: 2010-10-05
Dear DB Experts

- I have a file with .DBF format; how can I know which database is this??
Is it Microsoft database 5 or which version
Or FoxPro???

- I managed to open the file with a utility but all I get is corrupted data????
I also imported the file into SQL Server 2000 retrieved the table data and it was scrambled

- I need to import and export the same file in SQL 2005 file how can I do that??

Note: The file contains Persian Language I installed the Persian Characters on my regional settings and I am able to write these characters in any editor.


I hope my question is clear enough

Appreciate the fast response.
 
0
Comment
Question by:MOA81
  • 4
  • 2
9 Comments
 
LVL 24

Expert Comment

by:fridom
ID: 18807329
I'd bet on dbase format or Xbase format. It should be possible to access it via ODBC I'm sure that using dbase files as ODBC source should work.

Regards
Friedrich
0
 
LVL 8

Author Comment

by:MOA81
ID: 18807470
Dear Friedrich

As mentioned in my Question Ive been able to access the file and import SQL Server 2000

and I did that through ODBC

can you elaborate more on the point you mentioned  

can you make that out in some clear points how to export or import in 2005

and what is .DBF what kind of DB is this ?? what version ?? and why the data inside is scrambled
0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18807881
As fridom indicated the file is probably a DBase file or possibly a FoxPro file. There is no way to know the version without knowing where the file came from. Unless the version is stored somewhere in the file itself and you can see it from the properties of the file in Windows Explorer.

To import the data into SQL Server 2005 you can create an SSIS package using Business Intelligence Studio or you can create a linked server in 2005 to the DBF file.

How did you import it into SQL Server 2000?

The data is bprobably scrambled because you do not have the proper collation in the database you imported it to.

I would suggest creating a new database with the proper collation and importing into that database. Look at the Create Database TSQL command for the proper syntax on creating a database with a specific collation.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 8

Author Comment

by:MOA81
ID: 18807979
Guys


I already know its either Dbase or Foxpro I mentioned that in the question

and I already created a database with the correct collation and still scrambled

so far no help

Dear Both (so far) can you please mention the steps of the importing it should be that hard

I just want to make sure I am doing the right thing

I already have experience in SQL Server the part I am missing is how to deal with this Dbase file

0
 
LVL 24

Accepted Solution

by:
fridom earned 250 total points
ID: 18809308
you have to register the source in the data source application. You choose the dbase odbc provider. And then you can just access this database as any other ODBC source. First things would probably do find out what tables are there and what rows, then you can write something like
select * from some_table_in_the_dbf_file
and move the result in the SQL Server 2005 table.

This should do with any programming language supporting odbc. What else should we know about your data?

Regards
Friedrich
0
 
LVL 8

Author Comment

by:MOA81
ID: 18831375
Dear Friedrich
Do you any other easier way to do this ???
rather than creating an ad hoc third party program ???

isn't there any direct way to read from SQL Server 2005
0
 
LVL 8

Author Comment

by:MOA81
ID: 19167465
any more comments guys on this one, still i think there is a better answer, sorry to bother you with this one
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SLQ View not updating 10 47
Need Counts 11 42
SQL Server 2012 Row Selection 2 30
SQL Split character from numbers 3 18
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.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

758 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

21 Experts available now in Live!

Get 1:1 Help Now