There where several optoins that crossed my mind.
- Saving the list as template and importing it into WSS 2007.
- Exporting the WSS 2003 list to a spreadsheet and creating a new list in WSS 3.0 (or 2007) based on the spreadsheet.
- Worst case, copy and paste the data in DataSheet view.
But guess what, none of the above worked. When I tried the 2nd solution, I got presented with this beautifull error: Method 'Post' of object 'IOWSPostData' failed .
It was hard labour trying to find a solution. Finally I found it on this site: http://www.tek-tips.com/viewthread.cfm?qid=1330234&page=1
The solution is (as described in the above link) the following:
Open the Excel Add-In EXPTOOWS.XLA located in C:\Program Files\Microsoft Office\Office12\1033 by default.Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL). Comment out that line with a single quote and add the line lVer=2 so your Intialize() method should now look like this:
Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title
'lVer = Application.SharePointVersion(URL)
lVer = 2
End Sub
You only have to change this once, because you change the script of the Add-In. All future export spreadsheets will work!.Hope this helps...
* I had some more problems, but I guess they are related to my hosting company. When I try to import from the spreadsheet, I get this nice error: Cannot connect to the server at this time. Your list cannot be published. So to work around this error, I first imported it into a local WSS site, saved it as a template and uploaded this template to my online WSS hosting. Then I created the list. A lot of work maybe, maybe 10 minutes per List, but not as much as typing the whole thins again or copy paste each field. Here are some more workarounds for this problem: http://support.microsoft.com/kb/838703
