Help with importin text file

[marrett]

I am trying to import a text file

The file is not consistant i any way. I would like to import it into one field and then got through it line by line (W/VBA) and assign it to the proper field. Each line is to ling to a memo field. How can I do this.

Thanks,
Maria

 

[Travis]

You could use the Open Function or the TransferText Function (With an import Specification). The problem I see though is that without some type of structure you will never be able to use VBA to do the import (more then once).