Lotus Notes Automation

[Dugantrain]

I've been trying for the longest time to find a good source of information on Access/Notes integration, but there just doesn't seem to be a whole lot out there. We use Notes as our mail client at work and daily are sent Excel Workbooks (several dozens) which must be imported into one of my db's. I have the database set up so that the user can open a Common Dialog, select the .xls file, click Import, and it will TransferSpreadsheet the needed information. The only problem is that the file must be a Local copy in order for the Common Dialog control to find it, so we have to Detach all of these files, import them, and then Delete the files. I've searched the Forums and there's a good bit of information on going the other way (firing an e-mail to Notes from Access), so if anyone knows of a good source of information for accessing objects located on a Domino Server from within Access, it'd be much appreciated.

 

[martinjward]

DugTrain

Go onto IBM developerworks & serach out resources using the COM programming language.

I have a Access & Excel routines that uses COM to extract & process data in collabaration with VBA

 

[Dugantrain]

martinjward,
Thank you for your reply. Honestly, I haven't been an Access developer in years; I moved to C#, VB.Net, Sql Server a while back. I'm still glad you replied, I went ahead and had a peek at my posts from several years back for a healthy dose of entry-level nostalgia.