A temporary table is just that - temporary. It exists inside the db. As their name suggests, external tables don't.
I've just provided you with tips on how to load quickly from CSV. Now it's up to you to read the documentation and develope your own solution for your own needs.
If you want further advice, at least show willing, and post what you've done thus far.
Regards
T