>I would like to have some automated jobs to update SharePoint 2007 lists. I gather the information from four different databases and summarize the data into SharePoint. I use FoxPro to product the data and I would like to update the lists with FoxPro too. Manual entry into SharePoint from there, yuch!!!
>
>Does anyone know where custom list data is stored in the SharePoint 2007 databases? Is there an ERD for SharePoint 2007 somewhere that I can download?

Did you check if SharePoint has any API for this?