Software

Ask something
Discussion Locked

Import/Export Outlook Journal Entries

0 helpful
5 replies

by nxk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have a client who uses the Outlook 2000 Journalling for the client contacts. They wish export the data in the Journals to an Access 2000 database. However, when they run the import from Access 2000, the Contact field and the Company Name field does not get imported. When they try a link table option to the Journal folder, again the Company field and Contacts fields do not appear.
They then tried exporting the data from the Outlook Journal itself and found that they could then have the Company field with data in it, however the Contacts Fields - even though there was a column called Contact Name is not populated.

Can anyone tell me if this is an issue with Outlook Journal or with Access 2000?

Thanks
Kutty

5 replies

by xpertdragon

My suggestion would be to get your data into the simplest format possible, in order to sucessfully accomplish a good import/export operation. Both Excel and MS Access recognize Comma Separated Value Files (CSV's). If at all possible, I would attempt an import/export of this nature.

You can try Comma Separation by (Windows) and (DOS) format to see which one works best. The DOS format is going to export your data in the simplist ASCII format most likely. You should then be able to importa Windows or DOS (*.CSV) file into an existing or blank MS Access Table.

Best of luck!

Paul M. Chavez

by nxk

I have tried Exporting the Journal Entries into a csv file and the same results occur - i.e. the Contact Name field is empty.

This discussion is closed to new replies.