can't import address from access to outlook

R

Rose

I am trying to import addresses from an access 2003 database into my contacts
in outlook 2003. The database is information I exported from outlook before
have to reinstall windows etc. I have followed all the directions and the
window says it is copying to contacts but there is nothing in my contacts
after the import. I have even tried it through excel with same thing
happening. I recently reinstalled office professional edition 2003 after
reinstalling windows xp. I had imported my contacts from my hand held Palm
and all was fine until my husband syncronized with his new treo and wiped out
the contacts and left only his phone numbers behind. :) Thanks for any help.
 
S

Sue Mosher [MVP-Outlook]

Did you click the Map Custom Fields and tell Outlook how to match the Access table fields with Outlook properties?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
R

Rose

Thanks Sue but I did do that. Most of the fields were already mapped and I
added those that were not.
Rose
 
S

Sue Mosher [MVP-Outlook]

What folder are you importing into? It's wise to import into a new empty folder.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
R

Rose

Do you mean to create a new contacts folder. The contacts folder under
Personal folders is the one I have trying to import to and it is empty. I
will try creating another contacts folder and try again. Thanks. Rose
 
R

Rose

Success!!!! Thanks so much. Do I delete the other contact folder - is there
a trick to that? I can't tell you how many different ways I tried to import
- hours- I should have used this site a lot earlie.
Ros
 
S

Sue Mosher [MVP-Outlook]

No need to delete, just copy the imported items into it. If that goes OK, you can delete the import folder.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
R

Rose

I have one more problem here. My outlook mail won't recognize the new folder
- how do I get the default changed to the new folder or transfer the
information back into the original contacts folder? Rose
 
S

Sue Mosher [MVP-Outlook]

Please provide details of the symptoms you're seeing. Where exactly did you create the new folder?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
R

Rose

Something is wrong with the original contact folder. Somehow it is full with
displaying anything. When I open it there are are bunch of lines there as if
it is in the detailed address view but has no data. I am unable to copy
anything into it. It is like I need to reformat it in order to copy to it.
Thanks, Rose
 
S

Sue Mosher [MVP-Outlook]

Have you tried using a different view of that folder?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
R

Rose

Hi Sue,
I am not sure where you want me to click to show message etc but I think the
original contacts folder is full and the deleted contacts(wherever that may
be) is also full. I tried to delete all the information and it says the
folder is full. The only folder I see with deleted information is the one
that holds the deleted emails. The contacts folder says it has 65,500 items
in it although I can't see anything. When I change views it is still blank
but the design is there. I can't seem to find anything relating to "show".
Thanks, Rose
 
S

Sue Mosher [MVP-Outlook]

The contacts folder says it has 65,500 items
in it although I can't see anything.

That's undoubtedly the problem. It looks like you have hit the maximum number of items in a .pst file folder. You might want to see if Scanpst.exe can fix it -- see http://www.slipstick.com/problems/scanpst.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
R

Rose

Yes, all views are blank except you can see that the formatting is there. If
I try deleting part of the contacts it tells me the folder is full. I am
confused as to why it says there are 65,000 items (only have 400 contacts).
I did try importing many times so I assume it has added up - still can't be
seen. Isn't there some way to delete this folder and start over? My new
folder imported just fine except it is not recognized by the address book.
Thanks, Rose
 
S

Sue Mosher [MVP-Outlook]

DId you try running Scanpst.exe as I suggested?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
C

Clueless in Connecticut

my name is Stella and I, too, am trying to export or import whichever is the
correct term....take my access contacts and transfer them/drop them/copy
them...what ever is needed to get them into my Outlook format....my boss
wants to merge all 6,000 contacts from Access into Outlook for our Christmas
2007 mailing and I cannot make it work although I'm following the printed
directions....it states start with a b lank access page and then press
import....but I don't see import only export...not to mention this new Vista
program isn't very user friendly...I'm also hav ing problems getting labels
to merge, even using the wizard...it is all new and too Greek for little ol
me....can someone out there help me before the night before Christmas....I'll
keep searching for tutorials but I need someone from Microsoft help
desk...and you people out there to help me out!! my Christmas bonus depends
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top