Exporting contacts to Excel 97-2003

  • Thread starter Thread starter Hossam
  • Start date Start date
H

Hossam

I’m using Office 2007 and I used to export my contacts to Excel in the
previous version. Currently I’m getting the following error:

“Translation Error: An ODBC error has occurred in the Microsoft Excel
97-2003 translator while trying to write a record to the result file.
[Microsoft][ODBC Excel Driver] Unknownâ€

Appreciate any suggestions to resolve this issue.

Thanks,
Hossam
 
Hossam said:
I'm using Office 2007 and I used to export my contacts to Excel in the
previous version. Currently I'm getting the following error:

"Translation Error: An ODBC error has occurred in the Microsoft Excel
97-2003 translator while trying to write a record to the result file.
[Microsoft][ODBC Excel Driver] Unknown"

Appreciate any suggestions to resolve this issue.
Click to expand...


Export to csv format.
May we enquire as to the purpose of your export?
 
The main purpose is to backup my contacts, which I do every few months. In
addition I synchronise it with my cell phone. I used to do the same process
with OL2003, but with OL2007 it is not working!

Gordon said:
Hossam said:
I'm using Office 2007 and I used to export my contacts to Excel in the
previous version. Currently I'm getting the following error:

"Translation Error: An ODBC error has occurred in the Microsoft Excel
97-2003 translator while trying to write a record to the result file.
[Microsoft][ODBC Excel Driver] Unknown"

Appreciate any suggestions to resolve this issue.
Click to expand...


Export to csv format.
May we enquire as to the purpose of your export?
Click to expand...
 
Hossam said:
The main purpose is to backup my contacts, which I do every few months.
Click to expand...

Then don't export. All you need to do is to make a copy of your pst file
each time. that has all your email, contacts, calendar and tasks in it.

In addition I synchronise it with my cell phone. I used to do the same
process
with OL2003, but with OL2007 it is not working!
Click to expand...

as before, export to CSV file, open in excel, and "Save-As" Excel 97-2003
format file.
 
Thanks Gordon for your help, it worked.

Gordon said:
Then don't export. All you need to do is to make a copy of your pst file
each time. that has all your email, contacts, calendar and tasks in it.



as before, export to CSV file, open in excel, and "Save-As" Excel 97-2003
format file.
Click to expand...
 
I export my contacts from Outlook to Excel to so I can do a mail merge in Word. I can no longer perform this also because of 07. Do you know how I can get around this or fix so I can exporet into Excel?
I???m using Office 2007 and I used to export my contacts to Excel in the
previous version. Currently I???m getting the following error:

???Translation Error: An ODBC error has occurred in the Microsoft Excel
97-2003 translator while trying to write a record to the result file.
[Microsoft][ODBC Excel Driver] Unknown???

Appreciate any suggestions to resolve this issue.

Thanks,
Hossam
On Monday, February 25, 2008 3:31 AM Gordon wrote:
Export to csv format.
May we enquire as to the purpose of your export?
Click to expand...
Click to expand...
 
I export my contacts from Outlook to Excel to so I can do a mail merge in Word. I can no longer perform this also because of 07. Do you know how I can get around this or fix so I can exporet into Excel?
I???m using Office 2007 and I used to export my contacts to Excel in the
previous version. Currently I???m getting the following error:

???Translation Error: An ODBC error has occurred in the Microsoft Excel
97-2003 translator while trying to write a record to the result file.
[Microsoft][ODBC Excel Driver] Unknown???

Appreciate any suggestions to resolve this issue.

Thanks,
Hossam
On Monday, February 25, 2008 3:31 AM Gordon wrote:
Export to csv format.
May we enquire as to the purpose of your export?
Click to expand...
Click to expand...
 
I export my contacts from Outlook to Excel to so I can do a mail merge in
Word. I can no longer
perform this also because of 07. Do you know how I can get around this or
fix so I can exporet into
Excel?
Click to expand...

Word will use the Outlook Address Book service directly of Word and Outlook
are from the same Office suite. Why do extra steps with export? See this
for an example: http://www.gmayor.com/merge_labels_with_word_2007.htm .
 
Back
Top