I'm still curious why the TransferText method will not work for you, but nonetheless...

A normal SELECT query will just select data, it doesn't do anything with it. The SELECT * INTO table creates a new table based on the query results. If the ADD0DATA table already exists, you will want to use INSERT INTO, rather than SELECT * INTO. Not sure if the syntax you have is correct though.

Here's a good resource on the methods available for importing text files into Access:
ImportText.exe Importing Text into Access with ADO/RDO/DAO/Filesys/Automation

You can modify the logic to use declared variables, rather than form fields.

Regards,

Ax