+ 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,770

    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)

Similar Threads

  1. Iterative process to import multiple text files into multiple excel files
    By Ecth3lion in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2018, 01:04 PM
  2. Import Multiple Text Files into Same Sheet
    By loyalblue in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-12-2016, 08:52 AM
  3. [SOLVED] Import multiple text files via MultiSelect
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2015, 08:17 AM
  4. Import Multiple Text Files from a Folder using VBA
    By AGALLEGOS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2014, 01:54 AM
  5. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM
  6. Import multiple text files into excel
    By jdbaba in forum Excel General
    Replies: 1
    Last Post: 11-19-2011, 04:32 PM
  7. Import of Multiple Text Files
    By yanks6rule in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2006, 07:34 PM

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