Import certain data from a txt file

[ColonelMustard92]

Hi,

I have a txt file that constantly updates with new data. Is there a command to import the first 100 rows from the txt?

Thanks!

 

[rlv01]

No, there is no such command. Assuming you have a sufficient understanding of VBA programming you could, in theory, write a custom VBA macro to do it. Another possibility is Power Query. This is not my area of expertise, but I've been told something like this is possible, so it might be worth your time to post a question in the Power Tools forum here.