Hi
I wonder if anyone can help me.
I have a bunch of CSV text files (over 400) and want to add 2 leading spaces to the beginning of each row. So the rows would go from this to this. (quotation marks are only for format purposes)
"00??,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,C,11,59,0,6,4,4,6,6,4,5,6,5,20090319"
" 00??,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,C,11,59,0,6,4,4,6,6,4,5,6,5,20090319"
My VBA skills are not as good as SQL skills. I was thinking that to do this I would have to use the run sql command using this sql code on the first field. Right((" " & [field1]),6). This adds leading zeros to the first field in access.
But then using this method I would have to import each text file into fixed width text format on a loop and then run the sql code on it.
Is this a useful method or does anyone know of a better method.
Thanks
I wonder if anyone can help me.
I have a bunch of CSV text files (over 400) and want to add 2 leading spaces to the beginning of each row. So the rows would go from this to this. (quotation marks are only for format purposes)
"00??,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,C,11,59,0,6,4,4,6,6,4,5,6,5,20090319"
" 00??,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,C,11,59,0,6,4,4,6,6,4,5,6,5,20090319"
My VBA skills are not as good as SQL skills. I was thinking that to do this I would have to use the run sql command using this sql code on the first field. Right((" " & [field1]),6). This adds leading zeros to the first field in access.
But then using this method I would have to import each text file into fixed width text format on a loop and then run the sql code on it.
Is this a useful method or does anyone know of a better method.
Thanks
Last edited: