RE: WSS Imports

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

Thanks for using the SBS newsgroup.

From your description, I understand that you want to know if how to import
excel spread*** into WSS site. If I am off base, please don't hesitate to
let me know.

First please let me know if the WSS site is running on the SBS 2003 server
box and is called Companyweb. If yes, we can do as follows:

1. Go to Companyweb site, click Create menu at the top of the homepage and
then click Import Spread*** under Custom Lists.

2. Specify a name and then click Browse...

3. Select the Excel file containing the tasks, and then click Import.

4. In the import dialog, select "Range of Cells" in the Range Type box.

5. Select all the tasks including the heading to import.

After importing, all the tasks in the Excel file will be in the same list.
However, each row will be imported as a single item.

If you encountered problem, please check if it is addressed in the
following article:

You receive a "Cannot connect to server at this time. Your list cannot be
published" error message when you import an Excel spread*** to use as a
basis for a new list in Windows SharePoint Services
http://support.microsoft.com/?id=838703

More information:
About the Spread*** Web Part
http://office.microsoft.com/en-us/assistance/HP010127131033.aspx

Create a connectable Spread*** Web Part
http://office.microsoft.com/en-us/assistance/HP010128791033.aspx

I hope the information above helps. I am happy to be of assistance to you
and look forward to your reply.

Have a nice day!

Sincerely,

Jenny Wu
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
Thread-Topic: WSS Imports
thread-index: Acaa2io5Q+3GulSFR2eZGTQrG24zkA==
X-WBNR-Posting-Host: 67.108.88.52
From: =?Utf-8?B?TE1J?= <LMI@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: WSS Imports
Date: Wed, 28 Jun 2006 10:42:02 -0700
Lines: 4
Message-ID: <B6BFC07B-7E8B-42BA-9A03-80F21219A0A0@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.windows.server.sbs
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:278024
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.windows.server.sbs

How can i import an .xls spread*** full of information into WSS. I
create a
Tech support list that has every filed that is in the .xls *** however i
can;t seem to find a way to inport the .xls information into the WSS site.
Can this be done? I have WSS 2.0


.

Quantcast