exporting to access

[DRH192]

hello,

does anyone know how to export the contents of an inbox to a ms formate ideally ms access?

cheers

 

[pmonett]

Access can get the data itself via ODBC. Just create the proper ODBC entry on your Notes db, and let Access open the database.

Pascal.

 

[DRH192]

that sounds good, but how do i set up the ODBC? I do want to be able to add fields to the access table that holds the mail and do actually want to make a copy of the mail that I'm importing. will i still be able to do this...?

cheers

 

[pmonett]

In XP you find the ODBC Data Sources tool under Programs/Admin Tools.
Fom there the exact procedure is a bit foggy for the moment. I'll get back to you as soon as I have something.

As for adding fields, I guess you can do that on the Access side. You might even be able to upload your changes, but don't expect to be able to see the additional fields in Notes.

Pascal.

 

[woonjas]

If memory serves me right you'll have to install NotesSQL, to allow ODBC access to notes.

http://www.lotus.com/products/product4.nsf/wdocs/3243f3d81944584085256e20006db691?OpenDocument

Woonjas
IRC: #notes on EFNet

 

[lespaul]

no you don't need NotesSQL in order to have an ODBC connection. I write data to an AS400 via the normal ODBC connection and I don't think it's any different to an Access database.

leslie

 

[woonjas]

to connect from notes to some rdbms you don't need NotesSQL, just an odbc driver for the particular rdbms.

if you want to connect from access to notes using odbc you'll need notessql, unless there's another odbc provider for notes that I don't know about.



Woonjas
IRC: #notes on EFNet

 

[aelliott]

If you're interested in a Notes/Domino tool which exports Notes documents and views to the following formats:
* Access
* Excel
* XML
* CSV
* Word / RTF

check this out:

http://www.agecom.com.au/export