This video explains how to link a MS Access Table to a fixed width text file. MS Access only establishes a link to the text file data but data is not copied to Access database. MS Access creates a linked table and using datasheet view you can view the data in the text file. Any changes made to text file will be reflected in MS Access linked table. The data can not be changed using MS Access and if you try to change the data an error message is displayed.
