Access Externaldata Import

[Brian Mason]

I am trying to import my email ms outlook 2007 into ms sccess 2007 via Externaldata. Everything works fine but the attachments dont come across. I have even defined a field for the attachment and it still does not work. I am now assuming that I would need some type of vb script to do this. The problem is that I do not know vb script. Is there anyone out there that knows of a way or a script that does this?


EggHeadCafe - Software Developer Portal of Choice
Transparent NTLM Authentication With ADSI and ASP
http://www.eggheadcafe.com/tutorial...a-dd1b21b626c3/transparent-ntlm-authenti.aspx

 

[PieterLinden via AccessMonster.com]

I am trying to import my email ms outlook 2007 into ms sccess 2007 via Externaldata. Everything works fine but the attachments dont come across. I have even defined a field for the attachment and it still does not work. I am now assuming that I would need some type of vb script to do this. The problem is that I do not know vb script. Is there anyone out there that knows of a way or a script that does this?

EggHeadCafe - Software Developer Portal of Choice
Transparent NTLM Authentication With ADSI and ASP
http://www.eggheadcafe.com/tutorial...a-dd1b21b626c3/transparent-ntlm-authenti.aspx

One problem is that there's a one-to-many relationship between a message and
attachments. So if you use automation, you can loop through the attachments
collection of each message, and process them... save them somewhere or
whatever. I don't think I would save them in the database. You'd be better
off saving them in a folder somewhere, probably... Otherwise, your database
is going to bloat like mad.

there are examples of looping through your outlook inbox and grabbing
attachments all over the place. Google around - you'll find a bunch of them.