Hi,
I am creating a text file for importing into the accounting system.
I need to combine a few access fields together (else this would be easy) and I will need to limit the total length of the combined Access fields to 100 characters which is all the accounting program will import. The accounting program produces an error and stops importing instead of just cutting off excess text.
There may be a nice command for this but I couldn't find anything.
Any advice?
I am creating a text file for importing into the accounting system.
I need to combine a few access fields together (else this would be easy) and I will need to limit the total length of the combined Access fields to 100 characters which is all the accounting program will import. The accounting program produces an error and stops importing instead of just cutting off excess text.
There may be a nice command for this but I couldn't find anything.
Any advice?