Importing data from microsoft access

HCL Domino Domino Forum
1

hi there,

i’m wondering if anybody can help me with a matter that’s not so clear to me: importing data from ms access into lotus database.

how can i do this?

thank you

2

Subject: importing data from microsoft access

The new Data Connections feature in R6 may be your long term answer.

Your short term answer may be as simple as Saving your data table in Access to an Excel file, then creating a view in notes where the columns represent the same columns in the table. Then import the excel file.

Hope that helps.

-J

3

Subject: and check out how to use a .col file

See TLCC Tips for XPages, Notes and Domino - This tip: Importing Data into Notes and Domino

Howard

4

Subject: importing data from microsoft access

Take a look at this Sandbox demo:http://www-10.lotus.com/ldd/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/6704c9ebb583859f8525694d004e51b0?OpenDocument&Highlight=0,access

5

Subject: importing data from microsoft access

With DECS, LEI, or the ODBC classes in LotusScript.

6

Subject: RE: importing data from microsoft access

thanks a lot to everybody. you were very kind and your answers very quick

i ll try and i ll let u know.

thanks again

7

Subject: Try a powerfull tool

Try ANDI at http://www.bpjl.com

This tool will allow you to get your MS Access data imported into Lotus Notes database using ODBC. Additionnaly, you can synchronize existing data.