Power query error

STIRRELL

New Member
Joined
Dec 30, 2010
Messages
25
Office Version
  1. 365
Hi all, I am using the import function to import txt files that always has the same column headers, but I am getting an error message that it can not find the column called Load_Date, but when I open the TXT file I see the header. I do not need to see the load date and I selected remove columns, but I am still getting an error message that I can not see the Load_ Date Column. The import worked on 2 of 3 test imports and there is nothing different on the file that is failing. Any suggestions?

thank you all,
Sharon
 

Attachments

  • Inpurt Error.PNG
    Inpurt Error.PNG
    6.3 KB · Views: 1

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
613
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi, maybe there are leading or trailing blanks in that one file?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,090
if you are using the Import Wizard make sure you did not forget to check the box
hasheaders.png
 

Watch MrExcel Video

Forum statistics

Threads
1,114,208
Messages
5,546,549
Members
410,746
Latest member
Tcestnick
Top