I have data that needs to be exported to a fixed-length text file. One field (numeric)is required to be 0-filled and right-justified. I have tried setting the field’s format to 00000000000.The field appears correctly in Access, but it exports as left-justified and blank-filled.
Is there a way I can change the data in this field to be text, and include the zeros?
Any help would be greatly appreciated.
