Excel MS Query from Text File Data Source

NumberGuy1

New Member
Joined
Feb 6, 2013
Messages
9
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:
1607783085500.png


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:
1607783639667.png

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.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,295
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,786
Messages
5,655,298
Members
418,187
Latest member
polks111

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top