You can import data from a SharePoint list to Visio2007 by using the Data Picker Wizard.
On the Data menu, click Link Data to Shapes.
On the first page of the wizard, click Microsoft Windows SharePoint Services list, and then click Next.
On the Select a site page of the Data Picker Wizard, in the Site box, type the address of the Microsoft SharePoint site that contains the list or view that you want to import, and then click Next.
Prompt for a valid Web site address to start with http://, followed by the name of the server, and end with the path to a specific Web site on the server
On the Select list page, do the following:
Under List, select the list that you want to import.
Under Link Options, select either link to list or link to List view, and then click Next.
If you select link to List view, the Select View page opens. Under View, select the view that you want to import, and then click Next.