Task:: to import an EXCEL (.xls) spreadsheet into Sharepoint WSS 3.0
Im using Microsoft Excel 2007. I have succesfully created a Data list.
Next step - Design - Export - Export Table to sharepoint list
Specify address: http://companyweb
Name: Test Sheet
Description: Test Sheet
Step 2 of 2: Column / Data Type / Key Cell
all of those are filled with values from the data list'
Finish: An unexpected error has occured. Changes to your data cannot be saved.