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!

 

[Rose McMahan]

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?

 

[Rose McMahan]

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?

 

[Brian Tillman]

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?

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 .