Outlook 2003 and Access 2003

My goal is to add a record to an Access table for each individual email in
Outlook.

Exporting emails from an Outlook folder to an external file is perfect,
except for the date field which is missing from the export.

Is there a way to get the date into the export? or is there a better
approach to getting this information from Outlook to Access?

Thanks
tc

Thought I would post this for anyone's future reference

In Access, File>Get External Data>Import>File Type=Outlook()
This brings up the Exchange/Outlook Import Wizard
It browses your entire Outlook Folder structure
Pick a folder and it gets Imported into an Access table

You get everything as separate fields in each record for each email
Recieved (date/time)
From
To
Cc/Bcc
Subject
Body (memo field)
Message size
Whether it had attachments or not
and about 20 other cool fields.

"Tony Cannizzo" <tcannizzo.DeleteThis@bellsouth.net> wrote in message
news:dWsli.52037$Fo1.11472@bignews7.bellsouth.net...
> My goal is to add a record to an Access table for each individual email in
> Outlook.
>
> Exporting emails from an Outlook folder to an external file is perfect,
> except for the date field which is missing from the export.
>
> Is there a way to get the date into the export? or is there a better
> approach to getting this information from Outlook to Access?
>
> Thanks
> tc
>
>