Sometimes a direct connection to any LOB system is not available. In this case
you can export text files on a regular base and pull this data into a SharePoint
list automatically, e.g. once a day. If a primary key is available in your text
file, then changed data is updated only. That means, you can have RSS and change
notifications, workflows, additional fields or attachements and much more.

Here is how:
www.layer2.de/.../How-to-connect-text-file-to-sh\
arepoint-list.aspx

No programming required. For WSS 3.0 / 4.0, MOSS 2007 & SharePOint 2010.
Free Shareware download after registration.