Hi, I am trying to find if there is a way to set up an Access database which will export the data into a flat file.
I will have 10 columns of data that must have fixed number of characters per column. I need this exported into a text file with the appropriate number of characters per field, so for example for a field that has one character of data with a length of 5 characters, on the flat file I am expecting to see one character with four blank spaces.
If you need further information, please ask.
Thanks in advance for your help.
I will have 10 columns of data that must have fixed number of characters per column. I need this exported into a text file with the appropriate number of characters per field, so for example for a field that has one character of data with a length of 5 characters, on the flat file I am expecting to see one character with four blank spaces.
If you need further information, please ask.
Thanks in advance for your help.