Exporting contacts to Excel 97-2003

Hossam · Joined: 25 Feb 2008 Posts: 3

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

Archived from group: microsoft>public>outlook>contacts

Gordon · Joined: 12 Aug 2007 Posts: 152

"Hossam" wrote in message @microsoft.com...
> 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 · Joined: 25 Feb 2008 Posts: 3

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" wrote:

> "Hossam" wrote in message
> @microsoft.com...
> > 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 · Joined: 12 Aug 2007 Posts: 152

"Hossam" wrote in message @microsoft.com...
> 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 · Joined: 25 Feb 2008 Posts: 3

Thanks Gordon for your help, it worked.

"Gordon" wrote:

> "Hossam" wrote in message
> @microsoft.com...
> > 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.
>
>
>

Gordon · Joined: 12 Aug 2007 Posts: 152

"Hossam" wrote in message @microsoft.com...
> Thanks Gordon for your help, it worked.
>

YW!

Importing and Exporting Contacts I recently exported and imported my contact from one computer to another. If I up the contacts subfolder I can see the contacts that I imported, however, when I go to send or forward an email and hit the "To" there are no entries listed in my contacts. HE

trying to import from excel to contacts I am trying to import a file from excel to my contacts. I am at a window that says... the microsoft Excel file has no named ranges. Use Microsoft Excel to name the range of data you want to import. what does this mean and what do i do???

Uploading contacts from excel I use Outlook (not express version) and need to upload hundreds of e-mail address from an excel spreadsheet - only the addresses are listed - no names. Suggestions?

How do I export individual contacts from outlook to excel I am trying to export individual contacts from outlook 2003 to excel speadsheet. I know how to export all contact from outlook to excel. But I was wondering if there is a way to export indivdual contacts as oppose to all of them listed in outlook. Any hel

How do I export contacts to excel including customized field I've added custom fields to my OL contacts form, when I try to export my contacts to an excel spreadsheet, my custom fields are not included. How can I export my contact and include the custom fields?