Creating a text file from a query using a form

A

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
 
D

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?
 
Top