Import - query table - retain trailing blanks in fields
 

I am importing a flat file a fixed length 12 byte record.

I set up the worksheet for
Cell A1 - text, cell width=8
(data validation set to text with min and max length=8)
Cell B1 - text, cell width=4
(data validation set to text with min and max length=4)

My flat file has the following record 'Col1 Col2'.

I use a macro with a querytable command to get the record using
fixedcolumnwidth, specify text format columns, and specifying the
length of each column.

However, when the record is imported to the spreadsheet, the data in
Cell A1 is 'Col1' - without the trailing blanks. Is there a way to
use the querytable to import these fields into the cells and retain
any trailing blanks in the fields? If not, is there another method
to import a flat file with fixed length fields into the worksheet and
retain any trailing blanks in the fields...