?
Solved

Importing from Excel problems

Posted on 2006-11-28
3
Medium Priority
?
285 Views
Last Modified: 2010-04-08
Hi experts,

I've found some help by searching here but still can't get a proper import of names and address from an Excel file. Can you see what I'm doing wrong, please? I've got contact details in an Excel 2003 spreadsheet and different ones in Outlook 2003, and I want to combine them by importing the spreadsheet information into Outlook.

1. My own Excel contacts spreadsheet is arranged with each row representing a person. and the columns represent the fields such as first name, company, mobile phone number etc
2. To get the right format, I exported my existing Outlook contacts into a separate spreadsheet using default mapping. I then copied the column headers in that spreadsheet into a new worksheet in my contacts spreadsheet. I then copied the columns of data from the first worksheet into the appropriate columns on the new worksheet. Hopefully this put my data into the format that Outlook expects for an easy import. Not all of the cells have data in.
3. I then named all the columns containing data with the same name as Outlook had put into export columns in row 1, such as "FirstName". I did this by highlighting each entire column from row 2 to the last row in the data range (that rectangle containing data in any column), then clicking the cell name box on the top left and typing in the name and pressing Enter.
4. I then deleted the original worksheet, leaving just the single worksheet in the file, containing my data in the format exported by Outlook previously with all the data ranges named.
4. I then tried to import from my new spreadsheet into the Contacts folder. However when I got to the "Import a file" dialogue, I can see all my named fields with unticked boxes. If I tick the first box next to "Import "BusinessPhone" into folder: Contacts" I get "Map custom fields" dialogue coming up. This shows "From: MicrosoftExcel (new line) BusinessPhone", then it says "Value (newline) F1". I've got a list of fields in the "To:" side, and if I scroll down to show Business Phone and then drag "F1" into it and click OK I go back to the Import a File dialogue. Looks reasonable. I repeat this for all the fields in Import a file dialogue, which are all my named fields. Most times if said "F1" as above, but sometimes it said something that I recognised to be the contents of the cell in row 2 of that column. I don't know where it was getting "F1" from.
5. Then click Finish.
6. Lots of importing goes on, and I find I've now got literally thousands of address cards, mostly blank, some containing just the first name, others just the last name, and so on - a card for every single cell in the spreadsheets data area! It has failed to import the cells from each row into a single address card which is of course what I expected.

Under Contacts in Outlook, I've got an area on the top left that shows 6 rows, "Contact", "Contacts in personal folders", "Search results in personal folders", then the last 2 again, and finally "Search results". I'm puzzled by this too!

Thanks,

Stuart
0
Comment
Question by:StuartOrd
[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
3 Comments
 
LVL 30

Accepted Solution

by:
irwinpks earned 1000 total points
ID: 18026552
Save your Excel file as CSV and import it that way.
0
 

Author Comment

by:StuartOrd
ID: 18026695
Brilliant, that worked fine! Why don't they just tell us to do it that way...........?

Any idea why I've got the bit mentioned at the end? Tell you what, I'll post another question

Many thanks

Stuart
0
 
LVL 30

Expert Comment

by:irwinpks
ID: 18030125
I ran into that problem years ago, and found that CSV in it's raw form was easy to manipulate.

Thank you for the quick score! :-)
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!

Question has a verified solution.

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

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
This article will help to fix the below errors for MS Exchange Server 2013 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
Suggested Courses

765 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