Export field contents to comma dilineated text file

[GaryS]

I need to export email addresses from a field in a table to a comma
dilineated text file. What I've been doing is exporting the entire table to
an Excel file, stripping out the other fields and then importing back to
another Access table with only one field and then exporting it from there. I
know with a little code there will be an easier way. Any help would be
greatly appreciated.

 

[Klatuu]

Create a query with only the field you want to export, then use the
TransferText method to export the query to the file format you need. It may
be necessary to set up an import/export specification to get it exactly like
you want it.

 

[GaryS]

Duh! I couldn't see the forest for the trees. Of course a query, and then
it's easy to export from there.

Thanks!

 

[Klatuu]

Glad I could help, Gary.

(Watch out for the trees, remeber what happened to Sonny Bono)