Separate file with one field

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

Seems like fairly simple need but cant figure it out.

How do i export the contents of One field of a table into a .csv or a text
file, one record per line?

Thanks
Ramesh
 
Create a query that returns only one field.

Use TransferText (in code or a macro) to export the query.
 
Thanks Allen. Guess i ll have to find out about the transfer text function
and use it. Sure that will help.

Ramesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count field length in delimeted file and compare with predefined listof field length 8
Exporting chuncks 9
Export of text field trims leading zeros 1
Format problem on exporting a query to txt 1
Simple Methods to Export Gmail to Text? 1
How to import several csv files into 1 access table? 4
Search/Extract Specific Data from all fields in a table 1
Export large query from Access 3

Back
Top