Text file data all in first column

H

Hood

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
 
H

Hood

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).
 
Top