Dean Davids
dnod at aol.com
Thu Oct 27 08:48:12 CDT 2011
Have you considered importing into Excel and then export as tab delimited? I seem to recall that as an option in Excel and that would likely be possible to automate if the user has Excel on PC. Dean S. Davids On Oct 27, 2011, at 9:01 AM, Debbie <delam at zyterra.com> wrote: > 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 >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com