Import TXT files without VBA

[PcMax]

Hi

My curiosity, with excel 2016 managing a "Formula / Query" to import the string of a *.txt file.
Is this possible?

Thank you all for the suggestions

[snb]

What did you try ?

[PcMax]

Ciao

I've always imported txt files using vba code, two examples:
http://excelexperts.com/VBA-Tips-Import-A-Text-File
https://newtonexcelbach.wordpress.co...iles-with-vba/

These examples use both VBA codes, looking for alternative methods for reading a .txt file

If there was not a chance to read the data with a formula I'll give it a reason!

[snb]

A querytable can be created without VBA.

[PcMax]

Hi, snb

Thanks for the suggestion.
When opening the Excel spreadsheet, you can set up the automatic txt file update

Confirm that There is no indirect formula for a txt file
Thank you