Append multiple DBF files in PowerQuery

Hi,

how can I open and append multiple dbf files in power query at once ? I can use the path: from ODBC --> select the dbf tabels --> append it in PQ, but then I also have to load all tables used to make an append. Also when I choose From folder --> define the path --> I get the source data but I can't display Binary data from Content table.

Thanks for help !

Olly,

your functions probably works well but I still have a problem with drivers on my PC (here is the topic where you also try to help me) https://www.excelforum.com/excel-gen...wer-query.html.

Now when I filled the parameter MyPath in fnGetDBF function I received the error DataSource.Error: ODBC: ERROR [IM002] [Microsoft][Driver Manager ODBC]. It's strange because when I get the DBF file by From ODBC in PQ everything works well

Please Login or Register  to view this content.

It works but now I'm getting Formula.Firewall Error

Please Login or Register  to view this content.

I used yours queries from post #6. Maybe I made a mistake in translation. Probably it should be translated like

Please Login or Register  to view this content.

I set privacy settings for public and on the step combine tables in CombineDBFTables i receive an error

Please Login or Register  to view this content.

Olly it works. Sorry but I didn't know that in fnGetDBF function "dsn=dbf_pliki" refers to a driver. After changing the privacy settings everythink works well. Thanks a lot !!!

Hi Olly, I have a similar issue except that I have the file with a consistent file name adjtime.dbf, but it is in a different folder for each day i.e. 05192020\adjtime.dbf, 05182020.dbf.

I think your code in this case is similar to my problem, but the use of odbc is throwing me off because an odbc entry and folder name are a 1 to 1 correlation.

So I resorted to an oledb call that looks like this, which works great, but I need to parameterize the folder name?

= OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\Users\jzimm\Downloads\aloha\20200519;extended properties=dBASE IV", [Query="select * from [adjtime.dbf]"])

Good morning Olly, I am very new to this power query and I want to implement, raise multiple tables in DBF from various databases, all databases have the same tables, since each database belongs to a branch different.
I'm reading this but I can't understand how I should put it together. Can I pass you the base query that I have of a table and would you help me adapt it to be able to raise all of them more automatically?

From already thank you very much

let
Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\matiasvizzari\Documents\Lince\DPILAR\DBF\;extended properties=dBASE IV",
[Query="select * from [ped.dbf]"])
in
Source