Do data Export from Notes Database via VBA in Access

[LeanneGodney]

Hi there,

I want to export data from a Notes Database into Access programatically. I have linked tables in my database at the moment, but would prefer to do away with that. I'm interested in two methods:

1. I'm interested in doing some kind of query directly to the notes database that can select the exact data I want and perhaps paste it into a new table in Access? Is this possible? If so, can someone give me some sample code? I'm a vba developer, so notes programming is very very new to me...

2. I was also considering working with linked tables within Access, where it grabs the information that I want from the linked table and creates a new local table of that info. But I've been having troubles with that - for some reason it says there's too much data...

Thanks in advance!!
Leanne

 

[taupirho]

Leanne, check out my article at

http://the-big-o.port5.com/article66.html

This shows a way to read Lotus notes folders via VB so you might find some useful ideas there