Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate and include trailing blanks | Excel Discussion (Misc queries) | |||
Excel web query does not import table (from yahoo finance) correct | Excel Discussion (Misc queries) | |||
Microsoft Query sometimes adds trailing spaces to fields | Excel Discussion (Misc queries) | |||
Trailing blanks | Excel Discussion (Misc queries) | |||
Macro - trailing blanks | Excel Programming |