Text file data all in first column

[Guest]

Trying to import my text file into Query. Asks me to select columns, but all
the data is in first column, how do I create the text file from the back
office so it will put records in seperate columns.

Thanks

 

[Guest]

Look at Data==>Text-to-Columns

 

[Guest]

I know text to columns but the reason for using query on text files is that
the text files contain more rows of data than Excel can handle, therefore I
cannot manipulate data within Excel. The answer is probably going to be in
how my back office creates a text file, this is my area of knowledge
deficiency (AOKD).