+ Reply to Thread
Results 1 to 7 of 7

Import txt file using power query

  1. 04-26-2020, 10:37 AM #1
    kv.singh
    kv.singh is offline
    Forum Contributor
    Join Date
    10-30-2019
    Location
    GUJARAT,INDIA
    MS-Off Ver
    MS OFFICE 2016
    Posts
    134

    Import txt file using power query

    I am trying to import txt file in excel using M query using Fixed length record setting.Once I import file successfully.When I put new updated file in and try to run
    M query it is not importing correct data defined in M query.
    Actually when I first time imported txt file through M query it puts column number in source text file.Now when I replace this source file with new updated file correct
    data is not imported. Sir, every time I have to make changes in query when i Import updated source text file ?
    Reply With QuoteRegister To Reply
  2. 04-26-2020, 10:42 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Import txt file using power query

    I think it is a good idea to wait with posting a new question, till your other question is solved.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 04-26-2020, 10:47 AM #3
    kv.singh
    kv.singh is offline
    Forum Contributor
    Join Date
    10-30-2019
    Location
    GUJARAT,INDIA
    MS-Off Ver
    MS OFFICE 2016
    Posts
    134

    Re: Import txt file using power query

    Point Noted.
    sorry for Inconvenience.
    Reply With QuoteRegister To Reply
  4. 04-27-2020, 01:33 AM #4
    kv.singh
    kv.singh is offline
    Forum Contributor
    Join Date
    10-30-2019
    Location
    GUJARAT,INDIA
    MS-Off Ver
    MS OFFICE 2016
    Posts
    134

    Re: Import txt file using power query

    My previous question is solved. Kindly reply this query.
    Reply With QuoteRegister To Reply
  5. 04-27-2020, 01:46 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,795

    Re: Import txt file using power query

    You have been asked to provide a cross-post link in your previous thread, which is still required. Have you asked this question on any other forums?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 04-27-2020, 04:21 AM #6
    kv.singh
    kv.singh is offline
    Forum Contributor
    Join Date
    10-30-2019
    Location
    GUJARAT,INDIA
    MS-Off Ver
    MS OFFICE 2016
    Posts
    134

    Re: Import txt file using power query

    NO I Have not asked this question on any other forums.
    Reply With QuoteRegister To Reply
  7. 04-27-2020, 05:05 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,795

    Re: Import txt file using power query

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Power query missed columns when import data
    By afgi in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 03-24-2020, 09:15 AM
  2. Power Query Import Question
    By Zandor435 in forum Excel General
    Replies: 1
    Last Post: 01-20-2020, 06:07 AM
  3. Could not import data properly when using Power query
    By yeungcase in forum Excel General
    Replies: 1
    Last Post: 07-02-2019, 03:57 AM
  4. [SOLVED] Is there an option in Power Query to import Named Ranges
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-19-2018, 04:14 AM
  5. Power Query import issue
    By kao in forum Excel General
    Replies: 30
    Last Post: 01-13-2018, 06:13 PM
  6. [SOLVED] How can I make a cell truly blank when doing a Power Query import from CSV?
    By Don202020 in forum Excel General
    Replies: 2
    Last Post: 12-08-2017, 03:13 PM
  7. Power Query Import Binary Data Type
    By brent_milne in forum Excel General
    Replies: 0
    Last Post: 08-13-2015, 09:46 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1