Is there a VBA code to let export a query from MS ACCESS file, export it as a TABLE to another MS ACCESS file ?

OK ,
This is fine, creating a TEMP table, then exporting is fine.

To create a temp table, isn't there a VBA code to replicate an existing query directy into a table, as the SQL statement is lengthy; and is difficult to put inside VBA code

No need for VBA code
Do as described here
https://support.office.com/en-us/article/export-a-database-object-to-another-access-database-4e2cd6dd-e482-441e-88b5-aa5319a428a6

Your answers where good ;

But this post has some clearer code :

https://stackoverflow.com/questions/42528479/access-copy-result-of-query-into-table-with-vba?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa

The lines of VBA code you provided were really helpful , Thank you