Export a table to a fixed width text file using a macro in Access 2016

I have an Access 2016 database with a table and query that I want to export to fixed width text files monthly (I give a data example below). The problem is that I can't guarantee that the access database structure will remain the same. Due to this I can't use the built in saved exports feature in access. I have copied and modified a script that will create a schema.ini for me on the fly with the proper schema formatting, including field names, field widths, etc. The problem is I am uncertain how to use it to export the data. I was reading this rather informative web page about how to work with a schema.ini file but it references how to use it for import, not export:


I was originally trying to use the TransferText method but I just keep running into errors with it. Most sites I am reading that are newer seem to recommend using ADO commands now.
DoCmd.TransferText acExportFixed, "schema.ini", tableName, "C:\TestFolder\TestFile.txt", True

I am willing to use any method that works and am open to suggestions.

An example of my issue is that in one month it would be that the database table has 2 fields, both width 10:

fieldID Integer
fieldUserName Char Width 10

Select allOpen in new window

But the next month it could have 3 fields and different sizes:

fieldID Integer
fieldUserFName Char Width 25
fieldUserLName Char Width 25

Select allOpen in new window

I have a script that can create a schema file on the fly to account for the structure changes but I am not sure how to export the data using the updated schema file.

[TestFile.txt]
ColNameHeader = True
CharacterSet = ANSI
Format=FixedLength
Col1=fieldID Text Integer 10
Col2=fieldUserFName Text Width 25
Col3=fieldUserLName Text Width 25

Select allOpen in new window