Mach1pro
asked on
Import Outlook calendar pst file into Access
I have a stand-alone outlook pst file that is a calendar file. Is there a way to import this data into Access (using Access).
I'm wanting an Access table that would look just as if I had used the Export to File routine from Outlook.
If I have to enumerate through the data in the pst file, then I can just preset my table and import the records. That would
be fine also.
I'm wanting an Access table that would look just as if I had used the Export to File routine from Outlook.
If I have to enumerate through the data in the pst file, then I can just preset my table and import the records. That would
be fine also.
ASKER
Yes, I have Outlook installed. The problem is that I'm trying to automate a routine, and so far I haven't found any way to do it from Outlook. The problem with trying to Link or Import tables using the Outlook() or Exchange() files of type, is that it pulls the data in as if it was an email message, not an Appointment item. I could accept this if it was just a matter of the wrong field names, but there are certain fields that are missing such as Start and Stop time.
If you know how to write a macro that can be run from Outlook that will export a Calendar to an Access database, then I can make that work as well.
If you know how to write a macro that can be run from Outlook that will export a Calendar to an Access database, then I can make that work as well.
I've just been looking at google for clues. You may have already done so.
Your question is one of the most frequently asked and there appears to no possibility of doing this either from Access or from Outlook.
It seems that Outlook simply does not expose the relevant objects to allow you can get at them programmatically.
You can't even run the outlook export wizard through code.
Pete
Your question is one of the most frequently asked and there appears to no possibility of doing this either from Access or from Outlook.
It seems that Outlook simply does not expose the relevant objects to allow you can get at them programmatically.
You can't even run the outlook export wizard through code.
Pete
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This link got me on the way
http://support.microsoft.com/?kbid=253794
Please see my next question that will complete this problem
http://oldlook.experts-exchange.com/questions/20785735/How-do-you-select-a-personal-Outlook-folder-using-vba-code.html
http://support.microsoft.com/?kbid=253794
Please see my next question that will complete this problem
http://oldlook.experts-exchange.com/questions/20785735/How-do-you-select-a-personal-Outlook-folder-using-vba-code.html
If you have Access2000 or later you may be able to import it directly.
File>GetExternalData>Impor
Pete