Thanks so much guys for your input.

Mark, I was just going to start fiddling around with the odbc drivers and see if I could get any kind of connection to these files. The only way I've been able to get anything from it, is by creating a new view that contains all the fields I need, then exporting it as a lotus worksheet, then saving this worksheets as excel files and finally importing them into VFP tables so I can manipulate their data structure. Ultimately, we want to transport all this data plus the fixed data structure into MSFT SQL 7.0, but I wonder if I'm not asking for more trouble...

Rick, I will be trying what you've suggested and hopefully it works ok

Have a good one guys,

Gil





>I have to use Notes 4.5 for email with one of my clients.
>
>I have noticed that Notes does an object model. I have never tried fooling with it (I am not a big fan of the product itself), but it might be possible to write code that would iterate Notes information through the object model and then once you have the message objects you are interested in, dump the information to DBFs.
>
>To see the typelib info (if you have msword):
>
>1. Go into Word or Excel
>2. Press Alt-F11 (VB Editor)
>3. Choose Tools\References from the menu
>4. Put a checkmark next to lotus on the form that comes up
>5. Click OK
>6. Press F2 (Object Browser)
>7. Choose Lotus in the combo box at the top of the screen
>8. Explore! < g >
>
>Rick Hodder
>
>>>Hi all,
>>>
>>>I wonder if anyone knows of a way, tool, web site or anything that can help me to get data from a Lotus Notes based system into dbf format or anything else that later I can export to it.
>>>
>>>The export feature on the program is really bad (or maybe I don't know how to use it), because when trying to export the visible data into a worksheet all it exports is just those columns visible on document and not ALL the columns as I need them.
>>>
>>>I imagine that there's got to be a tool that will read an .nsf file and show me all the components and tables within the file (does it work like Access's mdb's or am I dreaming?)
>>>
>>>
>>>Thanks a WHOLE HECK of a lot
>>
>>Getting data from Notes is near impossible. Lotus has an ODBC driver that sucks at best [at least when I tried it]. What we do is either create a special Notes agent that writes all the fields for a specific table out to a delimited text file that we can import into a dbf. I also created a PRG [see File #9568] that creates a VFP export file in the format needed to import data into a Notes database.
>>
>>The other trick we do is have our Notes developers include Notes agents in the data entry forms that write data to Oracle tables on the fly [as changes, deletes and new records are added to Notes databases]. We then use VFP to access the data in Oracle. We also have geniuses that think Notes is a relational database system and is the ideal product for creating such systems. What a laugher.