Avatar of BleedBurntOrange
BleedBurntOrangeFlag for United States of America

asked on 

Outlook not taking imports

I have a client that has non-domain administrators unable to import CSV or XLS files into their contacts in Outlook while in their Terminal Server session. I am able to take the same files and import them, without fail, as the admin or as a member of the domain administrators group.

Until about 6 weeks ago users were able to import without any challenge. I suspect an update on the Exchange server; but do not know how to vet that information. The Terminal Server is running Server 2008 R2 with Outlook 2003. Exchange is 2007.

1. An error has occurred in the Microsoft Excel Translator while getting the contents of a file system.

The Microsoft Excel File <file location on terminal sever> hos no named ranges. Use MS Excel to name the range of data you want to import (click ok to dismiss).

2. A file error has occurred in the translator while trying to establish a filed map.
Unexpected error (53) occurred (click okay to dismiss)
OutlookWindows Server 2008Exchange

Avatar of undefined
Last Comment
Avatar of apache09
Flag of New Zealand image

I dont think it will be an issue with Exchange, but permissions on the Terminal Server itself

When you got it working for yourself, did you do this on your local PC?
Or did you also try it in terminal server?

I Also think the issue may be more related to the Named Range or ODBC settings / setup on the terminal server

Avatar of BleedBurntOrange


As administrator or a member of the administrators group, in Terminal Server is how we tested the import of the files into Outlook. The mechanics of how the file is imported have not changed. The user goes through the same process to import the contacts into Outlook as before, but this time getting the afore mentioned errors.

You are saying that the permissions have changed on the user so they can no longer import the files into Outlook?

Would a recent terminal server update (server 2008 R2) have made the change.
Avatar of BleedBurntOrange
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of BleedBurntOrange


It was not quite as cut and dry as creating new user profiles on the TS. There was a GP issue that prohibited the creation of user profiles, so they were only getting Temp profiles when they logging back in.  The GP was pointing to one AD server that did to have the correct GP, so it would not run. The GP were not replicating between the primary and secondary AD servers. I had to clean out the registry of the user.bak registry entries on the terminal server, and then rename the user profiles on the Terminal and AD server that hosted the roaming profiles. Once I did all that, the profiles re-created on the TS and AD servers when the users logged on. I configured Outlook and moved over users file from the .olds I renamed. Only then was the user able to import and map the CSV file.

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo