MOA81
asked on
How to import/Export .DBF into/From SQL Server 2005?
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.
- 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.
ASKER
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
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
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.
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.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
any more comments guys on this one, still i think there is a better answer, sorry to bother you with this one
Regards
Friedrich