Debbie
delam at zyterra.com
Thu Oct 27 08:01:44 CDT 2011
The line by line method is definitely in consideration. I was hoping for something that would be a little more friendly to the user who developed this db. You never know when someone on this list has the perfect elegant solution. Debbie Sent from my iPhone On Oct 27, 2011, at 7:01 AM, Arthur Fuller <fuller.artful at gmail.com> wrote: > That looks like a cleaner solution than my clumsy external method. > A. > > On Thu, Oct 27, 2011 at 7:56 AM, Paul Hartland <paul.hartland at googlemail.com >> wrote: > >> Could you not write a function to export the file line by line, put the >> file >> into a recordset, open a text file for exporting to and loop through the >> recordset and print each line into the file using something like >> >> Print #FileNumber, YourRecordset.GetString(, , vbTab, vbCrLf, ""); >> >> Has worked for me in the past. >> >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >