Solved

Import Excel to outlook problem

Posted on 2013-05-14
11
575 Views
Last Modified: 2013-05-15
dear
 i have problem when i have tried to import contacts from excel file microsoft excel 97-2003 format  to putlook 2007 as below
"an error has occurred in the microsoft excel 97-2003 translator while getting the contents of a file system.
Outlook was unable to retrieve the data from the file "c:\...... .xlx". verify that you have the correct file, that you have permission to open it, and that it is not open in another program."
0
Comment
Question by:Alkannetworks
  • 5
  • 5
11 Comments
 
LVL 93

Expert Comment

by:John Hurst
ID: 39164392
There may be some incompatibility in the Excel file. Open the Excel file, then Save As new file in .xlsx (new) format.

Now open Outlook and try to import contacts from new file.

... Thinkpads_User
0
 

Author Comment

by:Alkannetworks
ID: 39164425
ok but i didnt found option in outlook 2007 to import from .xlsx file to outlook ??
0
 
LVL 93

Expert Comment

by:John Hurst
ID: 39164447
In Outlook, when you import a file, it is looking for a format (like CSV). It should use the .XLSX file if you point to it. XLSX is native to Office 2007 and you have Outlook 2007 so this should work. Just point to the type of file you want.

In my Outlook 2013, the only option is CSV (or PST) and I recall this is the same as for Outlook 2007 and 2010.

... Thinkpads_User
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:Alkannetworks
ID: 39164496
dear
 i have choosen to ( import from another program or file ) after that i have choose comma seperated values but when navigate for the file it gives me only .csv files not .xlsx
0
 
LVL 93

Expert Comment

by:John Hurst
ID: 39164539
I see.

Close Outlook. Open your original Excel file and open a new (blank) Excel file alongside. Copy the contents only of the old file into the new blank file. Now in the new file, Save As very new name.csv.

Now you have a new, fresh CSV file.

Try again to import that and see if it works.
======================

If not, try an Office Repair. Go to Control Panel, Click on Office and select Change, Repair and repair Office. Then make sure that all 3 Service Packs are installed. Then patch completely.

Now restart and try the very new CSV file again

.... Thinkpads_User
0
 

Author Comment

by:Alkannetworks
ID: 39164601
dear
when i have tried to do that it give me message
" the selected file type doesnt support worksbook that contain multiple sheets "
0
 
LVL 93

Expert Comment

by:John Hurst
ID: 39164691
So then see if you can get what you need in one sheet in one workbook (remove all but one sheet).

Make a very simple test with about 10 names to see.
... Thinkpads_User
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 39164962
A few things:

1) Outlook 2010 does not support xlsx for import, so neither will Outlook 2007.  Use xls.  I have no idea whether this is still the case in Outlook 2013

2) The contact info you want to import from your Excel file must be included in a named range

3) Make sure that the Excel file is sitting in a directory you have full read/write access to.  Do not put it in a directory subject to UAC, such as c:\Program Files
0
 
LVL 93

Expert Comment

by:John Hurst
ID: 39165510
Outlook 2010 does not support xlsx for import,

True. I was thinking somehow the CSV file was in an incorrect format (which possibly cannot happen). That is why I asked (a) to remake the CSV file to eliminate errors and (b) to try as test with a short 10 record file to get it working.

.... Thinkpads_User
0
 

Author Comment

by:Alkannetworks
ID: 39168530
thanks i have did it manual
0
 

Author Closing Comment

by:Alkannetworks
ID: 39168533
thanks for u help
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

831 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