Creating a text file from a query using a form

[Ana]

Hi,



From my ade application I need to export a query into a file with a
delimiter text so it can be imported by an additional application. I use the
following cmd to create a file:



Dim stDocName As String

stDocName = "myReport"

DoCmd.OpenView stDocName, acViewNormal, acEdit



And then I use a txt file to save the output.

Unfortunately, the output format is not what I need. The format should be
something like: 1st column = 10 characters, 2nd column= 4 characters and so
on. Reason being is that my second application can read and import the text.

How should I go by?

TIA

Ana

 

[Duane Hookom]

Your question is confusing since you mention "delimit..." and then go on to
describe fixed width columns. Is your requirement both, one, or the other?
Can you provide sample output?