Solved

SBS 2003, Import Contacts into CompanyWeb/Contact list

Posted on 2006-07-06
2
951 Views
Last Modified: 2008-01-09
I am trying to import contacts into the "Contact list" within the "CompanyWeb" on a SBS.

I first tried importing the contacts from an Excel spreadsheet into a user's Outlook Contacts.  However, the Contact List import feature does not identify this users contacts to import.  Second, I created a web administrator/power user and imported the Excel contacts into that Outlook Contacts.  When I go to the CompanyWeb, Import Contacts - it allows me to do a drop down to all contacts, but none of the contacts are shown.

Simply, How do I import contacts into a CompanyWeb contact list?  It CAN'T be this difficult.
0
Comment
Question by:redvipergts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 total points
ID: 17062849
Since the Contacs is a "List" you can convert the Excel document into a list and then just attach it as a data source in SharePoint.

To make this easier, create a new Data Sheet View for your Contacts List (they offer this view in other areas by default, I don't know why the Company Contacts list didn't get one).  

To do this, Go to the Contact List in Companyweb, Click Modify Settings and Columns, at the very bottom is "Create new View".  Select Datasheet view, and then give it a name, check ALL field names, and click OK.

Then go back to the list and click on your new VIEW.  Then click on Task Pane > Query List with Excel.  You can have it create a new workbook and then copy and past your current Excel sheet into this new one.  Changes will automaticly be updated in SharePoint.

Jeff
TechSoEasy

0
 
LVL 1

Author Comment

by:redvipergts
ID: 17094029
That works.  Thanks Tech.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question