Sharepoint 2007 Spreadsheet import help please!!

[snips86x]

I'm trying to import a spreadsheet into Sharepoint 2007 and despite this working fine in my test environment, it fails in live.

My initial error was ''Post' of object 'IOWSPostData' Failed' and to resolve this, MS gave me the following fix:

1. Navigate to \Program Files\Microsoft Office\Office14\1033
2. Run EXPTOOWS.XLA
3. Amend the VBA code to look like this:

Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title
lVer = -1 ' can't tell STS server version
If Val(Application.Version) >= 12 Then
' lVer = Application.SharePointVersion(URL)
lVer = 2
End If
End Sub

This enabled me to select the file to import and choose the cell range. However, this game me a new error:

"Cannot connect to server at this time"

MS gave the following details:

In the root site, create a new list that is based on the Excel workbook. To do so, follow these steps:

1. On the home page of the root site, click Create.
2. On the Create page, under Custom Lists, click Import Spreadsheet.
3. Specify the options that you want, and then click Import.
4. In the Import to Windows SharePoint Services list dialog box, click the range of cells that you want to use for your list, and then click Import.
5. Specify the columns and the rows that you want to import, and then click Import.

In the root site, save the new list that you created as a list template. To do so, follow these steps:

1. In the root site, click Documents and Lists.
2. Click the link to the list that you want to save as a template.
3. Click Modify settings and columns.
4. On the Customize ListName page, under General Settings, click Save list as template.
5. In the File name box, type the file name that you want to use for the template file.
6. In the Template title box, type the title that you want to use for the template.
7. Click to select the Include content check box.
8. Click OK.

However, I am still unable to import this file into the root or subsite.

Anyone know of a workaround?

 

[snips86x]

When I have had problems like this in the past it just as easy to create the list manually, change the list to edit in datasheet and then cut and past the columns in.

Cheers mate.

I was trying to avoid manually creating the table due to the quantity of data involved, however I kind of had no choice as I had to get it done.

It turns out though, that once I'd kick started Excel into importing XLS files into share point lists, it just worked from there on in.