Does anyone know how to import MS Access databases? I am trying to create a Lotus Notes Database of helpful hints and import the data created from an Access database.
Subject: Import Access Database
You can use either the NotesSQL or Lotus Approach to do this type of import. However, you will find that Lotus Approach works best for large tables (10,000+ records).
Subject: RE: Import Access Database
It’s easy to do with LEI but you can also cheat and use DECS. First create a form that contains the fields you want to import. They don’t have to be named the same as the Access fields. Create an OLE DB connection document to the Access database (you must have Access installed, and the database file available, on the server where DECS is running). Create a “Virtual Fields” activity and specify the OLE DB connection as the source. Map all the Notes fields to Access fields. Select the option to “retain all fields”. Click “Initialize Keys”. This will copy all the data from the Access fields into the corresponding Notes fields, creating a document for each row.
This assumes you have just the one table – if you have more tables, LEI is better since you can do it by Replication. But you could also script it using the LC LSX.
Refer to the LEI redbook for all this stuff. I’ve posted a link in the EI Forum.
Subject: Import Access Database
If it’s a one time import, the easiest way would be to export the data from Access as a Lotus 123 file and import it into a view in Notes with the same column order.