+ Reply to Thread
Results 1 to 12 of 12

bulk query .DBF??

  1. #1
    Registered User
    Join Date
    05-24-2020
    Location
    argentina
    MS-Off Ver
    office 2016
    Posts
    9

    bulk query .DBF??

    Good morning , 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
    Please Login or Register  to view this content.
    Last edited by alansidman; 05-25-2020 at 03:03 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,260

    Re: bulk query .DBF??

    If I am understanding your request properly, you will need a parameter to change the file location/name to bring into PQ. Here is a tutorial on how to do that.

    https://www.howtoexcel.org/power-que...r-power-query/

  3. #3
    Registered User
    Join Date
    05-24-2020
    Location
    argentina
    MS-Off Ver
    office 2016
    Posts
    9

    Re: 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
    |
    |

  4. #4
    Registered User
    Join Date
    05-24-2020
    Location
    argentina
    MS-Off Ver
    office 2016
    Posts
    9

    Re: bulk query .DBF??

    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:

    Please Login or Register  to view this content.
    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.
    Last edited by matvizzari; 05-26-2020 at 12:11 PM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,086

    Re: bulk query .DBF??

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. I have done it for you this time.)

    You really do need to read the forum rules, please - there arenít many and they are simple, but you have broken two of them already.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,086

    Re: bulk query .DBF??

    If this is a Access query, say so and I will move it to the correct sub-forum for you.

  7. #7
    Registered User
    Join Date
    05-24-2020
    Location
    argentina
    MS-Off Ver
    office 2016
    Posts
    9

    Re: bulk query .DBF??

    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.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,086

    Re: bulk query .DBF??

    The rules are all in one place here: https://www.excelforum.com/forum-rul...rum-rules.html

  9. #9
    Registered User
    Join Date
    05-24-2020
    Location
    argentina
    MS-Off Ver
    office 2016
    Posts
    9

    Re: bulk query .DBF??

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

  10. #10
    Registered User
    Join Date
    05-24-2020
    Location
    argentina
    MS-Off Ver
    office 2016
    Posts
    9

    Browse excel with parameters, to combine tables and make a massive query .dbf

    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
    Please Login or Register  to view this content.
    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.

  11. #11
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,260

    Re: bulk query .DBF??

    Do not create a new thread for the same issue if you are updating information. Continue in the same thread with updated information. I have merged your two threads so that you may continue on this issue. Only start new threads for NEW problems or issues.

  12. #12
    Registered User
    Join Date
    05-24-2020
    Location
    argentina
    MS-Off Ver
    office 2016
    Posts
    9

    Re: bulk query .DBF??

    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

    Please Login or Register  to view this content.
    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
    Please Login or Register  to view this content.

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Power Query Refresh or Access Query - 2nd Query Run is faster
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2020, 10:16 AM
  2. [SOLVED] how do you unsubscribe in bulk?
    By TheVolkinator in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-13-2017, 03:17 PM
  3. [SOLVED] Validating bulk of url`s
    By v4ashish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2016, 08:46 AM
  4. Bulk Export to PDF
    By zincoxide in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2015, 09:14 AM
  5. Bulk signing
    By brian0412 in forum Excel General
    Replies: 1
    Last Post: 03-14-2013, 12:22 AM
  6. Transpose in bulk
    By Daisy10 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-27-2008, 02:26 AM
  7. Bulk Upload
    By Kris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2006, 10:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1