Exporting tables from access to text file

[pboochoon]

Hi,

I am not good with Vba. I want to export a table from an access database into a text file to be imported to another application. The fields are the same for both application but, not in the same sequential order. Can you assist me with sample codes to get this done please?

Thank you

[vb5prgrmr]

strSQL = "SELECT field1, field4, field3, field2 FROM tablename"



Good Luck