Hello! I am in dire need of assi

[BGrego]

Hello!

I am in dire need of assistance...I am trying to import data from a .nsf lotus notes db to a MS Access db. I understand how to create the ODBC connection, and I have imported tables using the views in the .nsf file, but the actual data that I need is in a form document within the .nsf file. I guess, my question is...how do I get the .nsf form data that I need into Access? Is there a way to do this using the import wizard, or should I use VBA? And if I should use VBA, can anyone assist?

I am a very proficient programmer, so you shouldn't have to be too descript. Any help given or a good link would be GREATLY appreciated.

Thank you
Brett

 

[grtammi]

Brett:

To my knowledge, I don't think there's anyway of directly importing from an nsf file to Access. You could try exporting the .nsf to a .txt delimited file, and reading it in that way? *shrug*

I've seen a utility somewhere (acc-technology.com???) that automates the process for you, but it's something like $50-$60 bucks with no demo ... don't remember why I was looking at it though ...

Greg Tammi, IT Design & Consultation
Work:

http://www.atsbell.com

Home:

http://members.shaw.ca/gregandliz