Text file data all in first column
 

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

Text file data all in first column
 

Look at Data==Text-to-Columns

"Hood" wrote:

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

Text file data all in first column
 

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

"Toppers" wrote:

Look at Data==Text-to-Columns

"Hood" wrote:

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