×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Importing data from Notes view to MS Access

Importing data from Notes view to MS Access

Importing data from Notes view to MS Access

(OP)
Hi all,
This is my first post in this forum.  
I am trying to get data from a notes view into MS Access.  The problem is, I created the view and only had the option to make it private.  So I don't know how to find it using ODBC.
Ultimately what I want to do is locate a document within LotusNotes and retrieve information from fields within the document.  I have been successful in retrieving column data from existing views within the desired database (views created by the LotusNotes gods of our company), but I can't get the field values.  My understanding is that field data cannot be retrieved using VBA.  So I thought that I would create my own view and include in the columns the desired data...problem is a private view cannot be searched (???).  So now I am trying to import that private view into Access using NotesSQL driver, but I cannot locate the view.

Please Help!!

Thanks,
Shane

RE: Importing data from Notes view to MS Access

Use the COM classes from within VBA to access the notes database and extract whatever information you need.

You won't be able to see a private view because it doesn't exist outside of your own desktop.

RE: Importing data from Notes view to MS Access

(OP)
Thanks dwarfthrower.  See Thread705-641772 for resolution if you're interested.

Shane

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close