in ms access how to export a query to a textfile programattically

Question

I am looking for a way to export a query or table to a text file in Microsoft Access programmatically. That is not using the export wizard. I found examples from other databases (ref below), but when I run the sql code in ms access ... select * into outfile 'c:/histdata/outfile.txt' from mytable ... ms access gives an error "query input must contain at least one table or query" (This is error 3067 in access 2016).

Thanks in advance.

ref: https://mariadb.com/kb/en/select-into-outfile/