+ Reply to Thread
Results 1 to 2 of 2

Import multiple text files

  1. #1
    Registered User
    Join Date
    07-29-2019
    Location
    Hungary
    MS-Off Ver
    2016
    Posts
    1

    Import multiple text files

    Hi

    I have around 700 text files. Every files contains 3 colums, this columns are double type numbers.
    How can I import these files at the same time?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,188

    Re: Import multiple text files

    Since you have Excel 2016...

    If you have all the text files in same folder. You can use binary combine method.

    Have a read of link for details. If you need more specific help. I'd recommend uploading sample text file(s) and expected result.
    https://exceleratorbi.com.au/combine...s-power-query/

    To upload, use "Go Advanced" button and follow "Manage Attachments" hyperlink. It will launch new tab/window for managing uploads.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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