Exporting contacts to Excel 97-2003

[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

 

[Gordon]

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.

Export to csv format.
May we enquire as to the purpose of your export?

 

[Hossam]

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!

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.

Export to csv format.
May we enquire as to the purpose of your export?

 

[Gordon]

The main purpose is to backup my contacts, which I do every few months.

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!

as before, export to CSV file, open in excel, and "Save-As" Excel 97-2003
format file.

 

[Hossam]

Thanks Gordon for your help, it worked.

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.

 

[Gordon]

Thanks Gordon for your help, it worked.

YW!