(I'm about to get on a plane, so I have to be brief. Sorry.)

Search Google for the keywords DoCmd and TransferText. Hopefully, this will get you closer to your objective than you are now.