Help exporting table to csv

[shabbaranks]

Hi guys,

I know how to use the manual export but it doesnt do exactly what I am trying to do. Im trying to export fields in a perticular order\structure but am not too sure about how to do it.

Table A has 3 columns Column1 Column2 and Column3 - the form whereby the user makes their selection displays Table A - Column1. What I would like to be able to do is based on Table A Column1 - Export its corrosponding field Table A Column3 as the is the code reference as opposed to the name reference of that row - hope I make sense?

Can anyone assist me with this please? Any questions let me know and I'll do my best to explain further

[shabbaranks]

After doing a little reading I would say I need to use DoCmd.TransferText to export - is this correct?

[boblarson]

Yes, DoCmd.TransferText SHOULD be able to do what you need, in conjunction with a query that pulls the data together the way you want to see it. If it doesn't get exactly what you want, you can do it in different ways, but TransferText would be my first choice.