Text manipulation Part 3

[Andy]

Not really, I can get the file into a 3 column ("neat-
rowed") table, but only after using the TransferText
(import) function in access, which as I say is un-
reliable. It is the TransferText Function I need to
replace. What I need is to setup an Array with a Custom
Datatype and then open the file manually and copy the
contents into the array. Then run the Querys to tidy up
the data as explained before. Trouble is to do this I
need each line of the textfile to be the same length. I
need to edit the textfile to pad each row with the
required number of spaces to bring them all to the same
length.
Sorry for any confusion.

Andy