Minor problem when using Access to back up Outlook

[dgoldstein]

I back up my Outlook folders as Excel spreadsheets. The easiest method I've found is:

1. Open the Outlook folder as a table in Access.
2. Copy the Access table and paste as plain text into the spreadsheet.
3. Delete the table from the Access DB.

Outlook's native export-to-Excel function doesn't export all of the information I need – this method does, and it's faster, too.

The only drawback to this method is that it creates two new Access MDB files each time (one in C:Program FilesCommon FilesSystemMSMAPI1033, and one in My Documents). No, it doesn't take long to delete them... But still, isn't there a way to avoid creating the two new MDB files, given that I don't perform any Save function in Access?

TIA,

Dan

[HansV]

Please don't ask the same question in different forums, it can only lead to confusion and duplication. This thread is locked.

Anyone wanting to reply, please do so in the thread starting at <post:=705,248>post 705,248</post:> in the Access forum.