Connection to MSACCESS Database

[sam2601]

Hi guys,

I need to connect to MSACCESS database and insert data from notes to Access.

Any ideas as to how i can accomplish that one.

Appreciate any help

 

[JuJutsu]

IBM WebSphere DataStage and DataStage TX should be able to do this, via ODBC connections.



JuJutsu - Jeff S.
Support Analyst

 

[pmonett]

LotusScript can also do that in R6, all you need is an ODBC connection. No need to purchase heavyweight software, but you do need a bit of time and programming to get it working.

Pascal.

 

[juliane26]

I think Pascal is right.

There is an Notes ODBC driver for free available.

http://www-10.lotus.com/ldd/notesua.nsf/0/94e14b09320416c7852569df005a97c9?OpenDocument

With that you define an ODBC data source on your notes DB. When selecting it gives you the choice to select the fields you want

I used this ODBC data source to extract notes data to excel and created an csv to import into my DBMS (not Access, and not having an ODBC Connector).
I guess if it is a one time task, even using excel in between should be fine. It can be scripted and automated.


Juliane