bulk query .DBF??

Good morning Alan, I spent the weekend trying to see if I could make the instructions you suggested work, but it gives me a syntax error, when I want to put the table name next to the row number, although I don't think it is exactly what What I need.
Thank you very much for your help.
I'm still down
|
|

Thank you very much for the answer, no, it is to see if you can consult all the DBF databases to be able to create dynamic tables, it is still in a trial period, that's why I see it with power query, probably in the future it will be to implement in Power BI, thanks, there I think you added the code tag, sorry, I'm new and I haven't seen that rule.
Thank you,
Cheers.

yes, follow the link in your previous answer, thank you very much

Probably I explained very badly, that's why it is not understood, sorry it is the first time that I work with this and I find it hard to put the idea into words.
I have an excel with a list of branches, in column F of that excel I have the names of each of the databases that I need to bring.
I would need to make a query that opens that excel, goes through column F (I calculate that with a for or while) and replaces the base name in the query path.

As I imagine:

Copy to clipboard

load Locals.xlsx
for i Locals row
******* BASE = Column 7.Row
next i
let
**** Source = OleDb.DataSource ("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C: \ Users \ matiasvizzari \ Documents \ Lince \ (BASE) \ DBF \; extended properties = dBASE IV",
**** [Query = "select * from [ctb.dbf]"])
in

Sorry for the horrors in the example of how I imagine it, but it is because I have no idea how to express it correctly.
From already thank you very much,
Cheers.

Good morning, I have already been able to solve the problem, if someone can help you, watching tutorials and reading about power query I found that having a reference excel and generating a GetData function for each of the necessary tables, I was able to bring from all the bases the tables and combine them into one, this is perhaps too punctual, I needed them agreed, but I share it in case someone ever serves it even if it is for reference

Getdata table Cli.dbf

 (Nlocal)=>
let
    Origen = Excel.Workbook(File.Contents("C:\Users\administrador.ESTANCIAS\Documents\Power BI Desktop\Sucursales.xlsx"), null, true),
    Sheet1_Sheet = Origen{[Item="Sheet1",Kind="Sheet"]}[Data],
    LOCAL = Sheet1_Sheet{Nlocal}[Column9],
    

    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Z:\LINCEV3\"&LOCAL&"\DBF\;extended properties=dBASE IV",
    [Query="select * from [cli.dbf]"])
in
    Source

the excel that is called in the query has an ID per database, the name of the database and the name of the directory folder that has the database

ex: 1 Castelar caste

Query calling Getdata

let
    Origen = Excel.Workbook(File.Contents("C:\Users\administrador.ESTANCIAS\Documents\Power BI Desktop\Sucursales.xlsx"), null, true),
    Sheet1_Sheet = Origen{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Encabezados promovidos1" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Tipo cambiado" = Table.TransformColumnTypes(#"Encabezados promovidos1",{{"UBICACIÓN", type text}, {"AGRUPAMIENTO", type any}, {"NOMBRE_LOCAL", type any}, {"NOMBRE_LOCAL_TOTAL", type any}, {"COD_LOCAL", Int64.Type}, {"CONCEPTO", type text}, {"SSS", type text}, {"TIPO", type text}, {"LOCAL", type text}, {"Activo", Int64.Type}, {"Orden", Int64.Type}}),
    #"Personalizada agregada" = Table.AddColumn(#"Tipo cambiado", "Personalizado", each GetData([COD_LOCAL])),
    #"Otras columnas quitadas" = Table.SelectColumns(#"Personalizada agregada",{"COD_LOCAL", "Personalizado"})
in
    #"Otras columnas quitadas"

I hope I have not made it very confusing, thank you all very much,
Cheers.