I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. . . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message news
I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. . . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed

After I select the destination folder is when my error message appears.
There is no subsequent screen that allows me to Map Custom Fields. Does this
have to do with the version/way I installed Outlook (2003)?

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message news
I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. . . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed

Is there something unusual about the way you installed Outlook that suggests that might be the problem? Have you tried running Help | Detect and Repair? Have you tried saving the Excel file as a .csv file and importing that comma-delimited file?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message ...
After I select the destination folder is when my error message appears.
There is no subsequent screen that allows me to Map Custom Fields. Does this
have to do with the version/way I installed Outlook (2003)?

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

"phd" wrote in message news
I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. .. . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed

Sue, thanks a lot. I tried saving the Excel file as a .csv file (didn't know
I could do that) and that worked. Right now I am trying the detect and
repair and it is taking forever...

"Sue Mosher [MVP-Outlook]" wrote:

Is there something unusual about the way you installed Outlook that suggests that might be the problem? Have you tried running Help | Detect and Repair? Have you tried saving the Excel file as a .csv file and importing that comma-delimited file?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message ...
After I select the destination folder is when my error message appears.
There is no subsequent screen that allows me to Map Custom Fields. Does this
have to do with the version/way I installed Outlook (2003)?

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

"phd" wrote in message news I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. .. . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed

Sue, again thanks. I ran the repair OUtlook wizard and tried again directly
from Outlook. This time it worked and gave me the opportunity to map the
fields.

"Sue Mosher [MVP-Outlook]" wrote:

Is there something unusual about the way you installed Outlook that suggests that might be the problem? Have you tried running Help | Detect and Repair? Have you tried saving the Excel file as a .csv file and importing that comma-delimited file?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message ...
After I select the destination folder is when my error message appears.
There is no subsequent screen that allows me to Map Custom Fields. Does this
have to do with the version/way I installed Outlook (2003)?

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

"phd" wrote in message news I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. .. . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed

Sue,
I have tried everything here but am still having no luck.

I created the .csv I am trying to import into Contacts from Outlook when I
knew I was going to have to have my hard drive reformatted. Now the program
will not import it back in. It gives me an error message saying the
translator cannot recognize the file.

I was able to open it in Excel. I tried saving it as an Excel file and
importing it that way. No luck. Keeps telling me too many fields defined. I
tried resaving it as a .csv under a new name. Nothing works.

I don't want to have to cut and paste nearly 300 contacts back into my
address book. I am using Office XP 2002 SP3 edition. Any suggestions on what
I need to do. I even tried running the detect and repair as you suggested,
but that didn't help.

If Outlook exported the .csv file why won't it import it back?

"Sue Mosher [MVP-Outlook]" wrote:

Is there something unusual about the way you installed Outlook that suggests that might be the problem? Have you tried running Help | Detect and Repair? Have you tried saving the Excel file as a .csv file and importing that comma-delimited file?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message ...
After I select the destination folder is when my error message appears.
There is no subsequent screen that allows me to Map Custom Fields. Does this
have to do with the version/way I installed Outlook (2003)?

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

"phd" wrote in message news I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. .. . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed

Assume that this is the same problem that I just responded to in another
thread.

If Outlook is complaining about too many fields being defined when importing
from Excel - did you include all the columns in your named range (A to IV)
or just the columns that include data. If memory serves correctly, Outlook
will throw that error message (too many fields defined) if more then 127
fields are found when it opens the file - negating follow-on screens from
appearing.

Karl

__________________________________________________ ___________
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com



"MoonStar" wrote in message
...
Sue,
I have tried everything here but am still having no luck.

I created the .csv I am trying to import into Contacts from Outlook when I
knew I was going to have to have my hard drive reformatted. Now the
program
will not import it back in. It gives me an error message saying the
translator cannot recognize the file.

I was able to open it in Excel. I tried saving it as an Excel file and
importing it that way. No luck. Keeps telling me too many fields defined.
I
tried resaving it as a .csv under a new name. Nothing works.

I don't want to have to cut and paste nearly 300 contacts back into my
address book. I am using Office XP 2002 SP3 edition. Any suggestions on
what
I need to do. I even tried running the detect and repair as you suggested,
but that didn't help.

If Outlook exported the .csv file why won't it import it back?

"Sue Mosher [MVP-Outlook]" wrote:

Is there something unusual about the way you installed Outlook that
suggests that might be the problem? Have you tried running Help | Detect
and Repair? Have you tried saving the Excel file as a .csv file and
importing that comma-delimited file?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message
...
After I select the destination folder is when my error message appears.
There is no subsequent screen that allows me to Map Custom Fields.
Does this
have to do with the version/way I installed Outlook (2003)?

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after
you select the destination folder.

"phd" wrote in message
news I receive the same error message and have tried everything "old
geezer" says.
Further I don't see where I can choose to custom map the fields
while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from
the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm
using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know
the version of
your Outlook, I'm thinking that I can give you a hint that
might work. So if
this doesn't meet your needs then maybe you can give a bit more
infomation
and some one else can help you. Here's how I did it! - (Im
starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the
OutLook
Contact file. Select the range of cells, "which Means to
highlight all the
cells in Excel that have information in them that you want to
import into
your outlook file". Do include cells that are header cells
(like the titles
of the columns) because outlook figures that you have headers
and if you
don't you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar"
(formula bar = A
bar at the top left of the Excel window.) {Or select
Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don't worry where the name will
go, it ends up
in the box. you just type the name (with no spaces) like,
clients).
3. Then don't forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get
another error -
, then go to OutLook, click on your contact folder, and add a
new folder
called Clients list. Click on the folder so it's selected This
is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select "File\Import and
Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client's names and
information when
asked. Also click on "don't import duplicate names"
b. Your destination folder is already selected cause you did
that in #4 above.
7. First time - In the "Import a file" dialog box put a check
into the
square next to the name of the file. When you do, the box
changes into a
"mapping" of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area
each cell title
so the transfer can be made. You must open each area on the
right map like
HOME or BUSINESS to fill in each field like home phone or zip
etc.
9. When you have mapped out the fields, then
"Finish" by click
OK and Finish and the transfer should work. So now you know.
.. . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no
folders appear in
the Destination Folder so I cannot select a folder and
continue. How do I
select the destination folder when there are none listed

Did you click the "Map Custom Fields" button to map the columns to Outlook's fields? Karl's tip about the named range is also crucial.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"MoonStar" wrote in message ...
Sue,
I have tried everything here but am still having no luck.

I created the .csv I am trying to import into Contacts from Outlook when I
knew I was going to have to have my hard drive reformatted. Now the program
will not import it back in. It gives me an error message saying the
translator cannot recognize the file.

I was able to open it in Excel. I tried saving it as an Excel file and
importing it that way. No luck. Keeps telling me too many fields defined. I
tried resaving it as a .csv under a new name. Nothing works.

I don't want to have to cut and paste nearly 300 contacts back into my
address book. I am using Office XP 2002 SP3 edition. Any suggestions on what
I need to do. I even tried running the detect and repair as you suggested,
but that didn't help.

If Outlook exported the .csv file why won't it import it back?

"Sue Mosher [MVP-Outlook]" wrote:

Is there something unusual about the way you installed Outlook that suggests that might be the problem? Have you tried running Help | Detect and Repair? Have you tried saving the Excel file as a .csv file and importing that comma-delimited file?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message ...
After I select the destination folder is when my error message appears.
There is no subsequent screen that allows me to Map Custom Fields. Does this
have to do with the version/way I installed Outlook (2003)?

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

"phd" wrote in message news I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. .. . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed

Thank you, Karl and Sue.

It took me a couple more tries, but I was finally able to import it using
the Excel file. very grateful. I was not looking forward to trying to re-do
nearly 300 contacts.

"Sue Mosher [MVP-Outlook]" wrote:

Did you click the "Map Custom Fields" button to map the columns to Outlook's fields? Karl's tip about the named range is also crucial.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"MoonStar" wrote in message ...
Sue,
I have tried everything here but am still having no luck.

I created the .csv I am trying to import into Contacts from Outlook when I
knew I was going to have to have my hard drive reformatted. Now the program
will not import it back in. It gives me an error message saying the
translator cannot recognize the file.

I was able to open it in Excel. I tried saving it as an Excel file and
importing it that way. No luck. Keeps telling me too many fields defined. I
tried resaving it as a .csv under a new name. Nothing works.

I don't want to have to cut and paste nearly 300 contacts back into my
address book. I am using Office XP 2002 SP3 edition. Any suggestions on what
I need to do. I even tried running the detect and repair as you suggested,
but that didn't help.

If Outlook exported the .csv file why won't it import it back?

"Sue Mosher [MVP-Outlook]" wrote:

Is there something unusual about the way you installed Outlook that suggests that might be the problem? Have you tried running Help | Detect and Repair? Have you tried saving the Excel file as a .csv file and importing that comma-delimited file?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message ...
After I select the destination folder is when my error message appears.
There is no subsequent screen that allows me to Map Custom Fields. Does this
have to do with the version/way I installed Outlook (2003)?

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

"phd" wrote in message news I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)

1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook file�. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate names�
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file� dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping� of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. .. . (I hope )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed