Sharepoint / Sharepoint Designer 2007
I have a sharepoint blog site and I need to add a company to each new post.
I created a list "Company" and a lookup column in "Posts" that uses the "Company" list.
I can now select a company from a drop down list when creating/editing a post.
What I need is to populate the "Company" list from a web service.
In Sharepoint Designer I added my web service to Data Source Library and clicking Show Data displayed it correctly in the Data Source Details window.
How do I connect this to my Sharepoint List?
At this stage I am open to both a 1 time dump of data or something that would update it periodically.