If you create a link list (default lists type: 103), the way to add a new SPListItem by code is quite tricky.

If you want to add an new url to this links list with these meta data:

url: “http://tom.vangaever.be/blog”
Description: tom's blog

you'll notice that there is no description property.

the example below shows you how to add a new item:
SPList linkslist = web["links"];
SPListitem newlink = linkslist.Add();
newlink["URL"] = "http://tom.vangaever.be/blog, tom's blog";
newlink.update();

NOTE: there must be a space after the comma, otherwise it won't work.

when you open the links list, you'll notice that the URL displayed is “tom's blog” and when you click on it… http://tom.vangaever.be/blog opens.

good luck

If you ever wanted to know why is office 2007 so much better than 2003 with SharePoint 2007?

this document will explain it all:

Microsoft Windows SharePoint Services 3.0 and Office SharePoint Server 2007 provide advanced collaboration and enterprise content management capabilities for end users through rich, contextual integration with Office Professional Plus 2007 and Office Enterprise 2007. These latest versions of their respective platforms were developed together for maximum integration, with the expressed purpose of enabling the most powerful user experience possible. While the 2007 Office Suites and Windows SharePoint Services 3.0 and Office SharePoint Server 2007 provide much new and improved functionality compared to their previous versions, the combined deployment of the latest client programs and server technologies is necessary to achieve the best Office and SharePoint integration features.
By leveraging the best Office and SharePoint integration features, you will be able to collaborate more productively, manage your enterprise