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

x
?
Solved

Import Excel to outlook problem

Posted on 2013-05-14
11
Medium Priority
?
658 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 99

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 99

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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 99

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 99

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 93

Accepted Solution

by:
Patrick Matthews earned 2000 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 99

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

877 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