Hello,

I'm wondering if it is possible to edit a connection like a MSQuery but using a file from a server. Let's say I have this file:

https://mysite.com/Folder1/Folder2/My_Text_File.txt

It is too big and I need to filter it by one of its fields, let's say it contains three fields: Country, Name & Email. Is there a way for me to filter it by a single Country at the import?

What I'm using to connect the file is the option Get External Data> From Web and then Import.

I'm using Excel 2010.

Thanks in advance!
DP