R
Rick
Please forgive me if this has been covered before, I could not find any
previous posts on the subject.
I am trying to Import contacts to a new Contact Folder from Excel. I have
setup the worksheet, included a row with column names, and saved it as a
..csv file. I saved it to my C:\ directory to remove any possibility of
network problems.
I then use the Import a File Wizard in Outlook, select to import a .csv,
pick my file (named BusContacts.csv), and select the new contacts folder I
created "Business Contacts". When I hit next I receive this error:
---------------
Translation Error
A file error has occurred in the Comma Separated Values (Windows) translator
while initializing a translator to build a field map.
Outlook was unable to retrieve the data from the file "C:\BusContacts.csv".
Verify that you have the correct file, that you have permission to open it,
and that it is not open in another program.
OK.
---------------
I do have the correct file, I should have full permissions and it is not
open in another program (not only is the file closed in Excel, but I closed
Excel too!).
I ran the Office 2003 setup again and setup to have the Importers and
Exporters "Run from My Computer" - per the instructions I found on this page
(http://www.pctoday.com/techsupport/detail.aspx?guid=&ErrorID=24656).
It seems to me that this a problem with the .csv translator rather than the
data file itself.
Any and all help on this topic would be greatly appreciated. Thank you in
advance. ~ Rick....
PS - Before actually *reading* how to use the import/export, I attempted to
import this data as an Excel file. Although it would allow me to progress
and assign fields and all that, it would begin the import (progress bar
appears and moves along) and when it got to the very end (progress bar 99%
full) it would hang up Outlook and crash it. When I would restart Outlook,
that new contact folder had many blank entries and was attempting to Update,
but would just hang. I deleted that contact folder and created a new one for
the above. Not sure if any of that matters, but I'm trying to be thorough. ~
Rick...
previous posts on the subject.
I am trying to Import contacts to a new Contact Folder from Excel. I have
setup the worksheet, included a row with column names, and saved it as a
..csv file. I saved it to my C:\ directory to remove any possibility of
network problems.
I then use the Import a File Wizard in Outlook, select to import a .csv,
pick my file (named BusContacts.csv), and select the new contacts folder I
created "Business Contacts". When I hit next I receive this error:
---------------
Translation Error
A file error has occurred in the Comma Separated Values (Windows) translator
while initializing a translator to build a field map.
Outlook was unable to retrieve the data from the file "C:\BusContacts.csv".
Verify that you have the correct file, that you have permission to open it,
and that it is not open in another program.
OK.
---------------
I do have the correct file, I should have full permissions and it is not
open in another program (not only is the file closed in Excel, but I closed
Excel too!).
I ran the Office 2003 setup again and setup to have the Importers and
Exporters "Run from My Computer" - per the instructions I found on this page
(http://www.pctoday.com/techsupport/detail.aspx?guid=&ErrorID=24656).
It seems to me that this a problem with the .csv translator rather than the
data file itself.
Any and all help on this topic would be greatly appreciated. Thank you in
advance. ~ Rick....
PS - Before actually *reading* how to use the import/export, I attempted to
import this data as an Excel file. Although it would allow me to progress
and assign fields and all that, it would begin the import (progress bar
appears and moves along) and when it got to the very end (progress bar 99%
full) it would hang up Outlook and crash it. When I would restart Outlook,
that new contact folder had many blank entries and was attempting to Update,
but would just hang. I deleted that contact folder and created a new one for
the above. Not sure if any of that matters, but I'm trying to be thorough. ~
Rick...