RE: trouble creating list via spread*** import

I'm having the same issue as Jason. I'm not able to open the .xla file
listed below. Are there any other trouble shooting options?



""Steven Cheng"" wrote:

Hi Jason,

Have you got any progress on this issue or does the issue information in my
last reply help some? If you still suffer the problem and need some urgent
help, I suggest you consider contacting CSS for further troubleshooting.

Best regards,

Steven Cheng
Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we

can improve the support we provide to you. Please feel free to let my
manager know what you think of

the level of service provided. You can send feedback directly to my manager
at: msdnmg@xxxxxxxxxxxxxx

This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
From: stcheng@xxxxxxxxxxxxxxxxxxxx ("Steven Cheng")
Organization: Microsoft
Date: Wed, 05 Mar 2008 05:04:51 GMT
Subject: RE: trouble creating list via spread*** import


Hi Jason,

Based on the problem symptom, I've looked up some former issues. It seems
there are two possible problems you may have run into:

ISSUE 1
=============
Cause:

When selecting the fields to import from the excel spread***, if the user
only selects the rows a range is specified like $1:$1. This range means
that all
columns in row one are selected. SPS 2007 has a limit of 1000 columns of a
single data type. The range $1:$1 uses the maximum number of columns
allowed in excel which is well over the SPS 2007 limit.

Resolution:

The customer should select the entire range of data to be imported
including the rows and columns. This should look like $A$1:$D$3.

Additional Information:

The maximum number of columns of a single type allowed in SPS 2007 is 1000.
This is equivalent to the Excel column lettered ALL. The "An unexpected
error has occurred. Your table cannot be published." message can also be
logged for several
other reasons.

For the "Method POST of object ‘IOWSPostData?failed." error message the
wrong post method is being used. This has been seen when using basic
authentication on the site. If this is the case the following can be done:

1. On the client where the import is being done from modify the
exptoows.xla file
to set lver = 3. This is a client side workaround.

=======================

Another issue is somewhat related to the sharepoint site's servername(in
url):


CAUSE:
====
Due to the FQDN internet explorer does not trust this URL to accomplish
this functionality and we need to add the FQDN to the intranet sites zone
for it to work.

RESOLUTION/WORKAROUND:
===
We've seen this problem when the address is an FQDN even though it’s
internal and adding the site to the Intranet sites in the IE options fixes
this problem.

We also needed to reboot the client machine after making this change which
suggests some sort of caching that was going on in the environment.

===============================

You can verify the issue based on the above issue description and try to
see whether that's the cause of the problem you encountered.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
From: =?Utf-8?B?SmFzb24=?= <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx>
References: <9825E030-BF94-459E-9F03-734AB219FD0A@xxxxxxxxxxxxx>
<953CFCF1-13B7-40A8-BF54-89769EDED773@xxxxxxxxxxxxx>
Subject: RE: trouble creating list via spread*** import
Date: Tue, 4 Mar 2008 12:16:06 -0800


i have tried different spreadsheets, and as little as 1 colum with 1 row of
data.

"Ace" wrote:

How much data do you have in your spread***? I suggest that you try a
test
import with several rows first.

"Jason" wrote:

When trying to create a new list using Import from Spread*** it is
failing
with

object doesn't support this property or method

and then:

method 'post' of object 'IOWPostData' failed

Using excel 2003, same result on both WSS2.0 and 3

Any suggestions?



.