Exporting a table to a fixed width in Access 2002
Posted on 2005-03-01
I have a command button on a form that runs a bunch of queries with the end result producing a table called final_tbl.
The table then gets exported as a text file to be uploaded to our mainframe. The exporting of the table works fine but I was thrown the following curve. The final_tbl contains fields like ticket, quantity, location, and so on. When uploading the text file into our mainframe it must match or line up against and 80 column record length or line position. So for example the first field which is ticket must be uploaded and start in position or column 2 When I look at the text file it starts ticket in position 1. This is a problem for the rest of my fields as well. I thought I could go into the export specification wizard and change start/width from 1 to 2 along with the rest of my fields but I get an error message that says "there is a gap between fields and ticket. So my question is how do I set a fixed range for my fields that have gaps:
Example: ticket (field length is 5) (needs to be in position 2), quantiy (position 9) leaving a gap between position 8 and so on. I hope I made sense.