Excel MS Query from Text File Data Source

[NumberGuy1]

I am trying to query a CSV file in Excel using Data | Get Data | From Other Sources | From Microsoft Query. I found a tutorial on the Internet that shows Text File among a list of Data Sources from which to choose:

However, when I try this myself, the list of acceptable data sources doesn't include Text File as an option, it only shows dBASE Files, Excel Files, and MS Access Database:

I have tried this on three different computers, and Excel shows me the same list of choices in Excel 2010, Excel 16 (Home and Business 2019), and Office 365. Is there something I can do to add Text file to my list of Data Sources from which to choose? Thanks.

 

[Norie]

When you click OK with <New Data Source> is there an option for Microsoft Text Driver in the 1st dropdown?

Note, to activate that dropdown you'll need to enter a name for the data source, e.g. Text Files.

 

[NumberGuy1]

Yes. That did the trick. Thanks, Norie!