Load data from DBF file in Power Query (Get & Transform Data)

[Zaigham]

Hi,
I want to load data from a dbase file "dbf" (generated by an old software, I am not sure perhaps it is Fox Pro) to be used in an Excel file after getting transform it in Power Query. To do so, I have tried many options available in Get Data>From Database> but none had worked. Alternately I have opened the file in Excel and saved it as *.xlxs then the data was loaded in PQ. By this procedure, every time I have to open and save file in excel format.

Is there any way to load data directly from dbf file to Power Query?

Regards

 

[alansidman]

See if this link helps you -->How to add dbf file with over 1M rows to power query ?