Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 962
  • Last Modified:

SBS 2003, Import Contacts into CompanyWeb/Contact list

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
redvipergts
Asked:
redvipergts
1 Solution
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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
 
redvipergtsAuthor Commented:
That works.  Thanks Tech.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now