Importing text into Access via autoexec macro

[RamLaramie]

I need help! I am trying to import a text file into Access via an autoexec macro. I also need to parse the data (Delimited by **)into a fixed table. I have some very rough ideas on this, can anyone help. It would seem to be a very simple process, but is becoming more challenging the more I get into it. By the way, the .txt file is coming out of Lotus Notes R5. Thanks

 

[dvannoy]

you should probally post this in the access forums.