How to

[Guest]

I am trying to import thousands of emails in Spanish from Outlook (Western
European encoding) into Access. I need both the receieved date field and
email message field in Access and am having this problem.

1) When I use Outlook export command, I can get correct Spanish fonts but
cannot export date fields.
2) When I use Access import (or link) command, I can get date fields but
Spanish encoding such as accents is lost.

Is there any way I can get both fields properly in Access?

 

[John Nurick]

As far as I know you'll need to use Automation to do this. These links
should get you started (or at least familiarise you with search terms
for further investigation):

OL2000: How to Programmatically Import Outlook Items from Microsoft
Access
http://support.microsoft.com/?id=208232

Using Automation in Microsoft Office Access 2003 to Work with Microsoft
Office Outlook 2003
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/odc_ac_olauto.asp

Accessing Microsoft Exchange and Outlook Data Using Visual Basic
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnout98/html/olexcoutlk.asp

Finally, the best places I know for information about Outlook are
http:www.outlookcode.com and http://www.slipstick.com