Export records to text file through SQL query

[ganraj]

I am looking for a query something like this to run in ADO:

db.Execute "SELECT * INTO [Text;database=c:\testdata]. HEADER0.txt from mytable"

The above query runs in DAO but not is ADO.


Any Help?