Import DBF File into Excel (Step-by-Step Guide)

1.    Open new excel file.

2.    Click on data tab.

3.    Click on From Other Sources and then on From Microsoft Querry.

4.    Select <New Data Source> and click OK button.

5.    Assign any name to your data that you want to import.

6.    Select driver for the type of your database, in this case you select Microsoft Access dBase Driver           (*.dbf,*.ndx,*.mdx).

7.    Now click Connect button and on next dialog box uncheck Use Curren Directory.

8.    Now click Select Directory and find your desired DBF file folder, in this case my file is located in           E:\ so I select E drive and click ok.

9.    Now folder is selected click OK again.

10.    Now Select your desired file by click on dropdown list and click OK.

11.    Click OK again, Querry wizard appears, now select your columns and send them in next list on             right.

12.    By clicking next you can assort your data by columns one by one, then click next.

13.    Final step click finish and then click ok or select your desired cell where you want to import data.

14.     Result look like this.

Thanks.