Import Data from MS Access

I need to import data from a MS Access database. How can I accomplish this?

Subject: How many times?

Subject: RE: How many times?

I just need to import a couple of tables into a LN database. So if your asking how many tables 2 how many time I need to do this once.

Subject: RE: How many times?

It was the “how many times” part that was the question. If it’s something you just need to do once, you can export the tables from the Access (or other) database to a spreadsheet or CSV and import them into Notes. If, on the other hand, you needed to maintain some sort of data synchronisation, then you would have to create code that runs on schedule and uses ODBC (or some other database connector) to pull data to Notes or use COM (or NotesSQL) to push data from Access.

Subject: RE: How many times?

Just once then. I will try to export out to CSV and then back into notes.