How to read dbf file &import structure & data in sql server

Priyanka Kumari

7y1.1k

I am new to dbase technology,I have a requirement,where by i have to read and import dbf data in sql server.

I have a folder which contains many dbf file(enclosed attachement) .Firt tell me,how i will come to know that,which is actual dbf file.

Plz help me out,I don't know anything in dbase.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy7y ago
If you are not having access to ask the one.
Then, import all the .DBF files because all the files are differ to each other with different sizes in the folder.
So, Every file can be treated as database object.
Hope you understood. If not come up with your query please.
Thank you.
Priyanka Kumari7y ago
Your words are vauable to me,since i am not fully satisfied with this solution,i am not marking it as reply.
Sreekanth Reddy7y ago
Hi Priyanka Kumari,
It's completely based on your need.
In your files, you are having multiple .DBF files.
So, Firstly ask the one who gave you these files which DBF file needs to get imported.
If they say all files needed then at any way you needs to import allfiles.
If they said any specific then import only that particular.
For the process of importing follow the below URL :
https://www.mssqltips.com/sqlservertip/2463/importing-dbf-files-into-sql-server/
If it helps mark as answer. Else come up with your query.
Thank you.