Import Text File to Access Table using Excel VBA

Hi

I have an new access database, where I have to import some text files using excel VBA. Is it possible. I need the exact query to automate this process.

So what I basically need to do is, use an excel macro, which import the text file to a table into the access db. But i don't want to run any query on acess database.If this is only possible through access vba, i don't have any idea to remove the module automatically, every-time i have to remove the module manually. Is there any any way to drop the module using the code. I don't want my module to be available in my database.

I am completely new to Access database and have no idea where to begin. I have basic knowledge of Excel VBA.

Any help will be greatly appreciated!!