Hi,
it is not a complex task, if you are new to programming...
try to look at help samples of opening recordset, looping through it records
and how to output text file (Print # statement) - hope this will give you an
idea how to start

I usually do this sort of thing with the WriteToFile() function at
http://www.j.nurick.dial.pipex.com/Code/VBA/WriteToFile.htm. Provided
your security settings are not too stringent, you can call WriteToFile()
in a query, using fields or calculated fields as arguments, and it will
create the text files as a side effect of running the query.

For instance, this calculated field:

 Result: WriteToFile([Contents], "C:\Temp\wtf\" & [Filename])

creates a textfile for each record in the query, placing it in the
specified folder, taking the filename from the [Filename] field and the
contents of the file from the [Contents] field.

It's up to you to use calculated fields in the query that format the
text the way you want it.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.