[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


@DbColumn lookup from embedded Excel Workbook

Posted on 2004-10-06
Medium Priority
Last Modified: 2013-12-18
I would like create a Dialog List field (field name: DktDest).  The field choices will be  obtained by doing an @DbColumn lookup using data from a form-embedded Excell Workbook.  The embedded Workbook is named "Datakit Worksheet", the worksheet is titled "Alpha Dest" the column is "Dkt Dest" (Column A).  In my efforts to make this work, I tried referencing a "named range" (this range is named "DktDestProp") in the embedded spreadsheet, but was still unsucessful!

Question by:rognyn
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 24

Accepted Solution

HemanthaKumar earned 2000 total points
ID: 12241264
You have to import the excel data into a lotus notes view.. and then use DBColumn on this view..


Expert Comment

ID: 12244233

Yes, the efficient way to accomplish this is to import the excel document into a view.

Create a form named Import. Create all the fields you want to import from the excel document in this form.

Only keep the relevant data in the excel that you want to import. Lets say you are importing two columns from the view.
ColumnA , ColumnB. (These are the titles in the 1st row in the excel document)

Create two text fields in the form called ColumnA and ColumnB in the import form.
Now go to the excel document and do a save as and then save it as a .wk4 file.

Now create a view in Lotus Notes which has Select FORM = "Import".  Create two columns ColumnA, ColumnB in the view.

Then go to the view, click on file , import.

choose file types as Lotus 1-2-3 and then select the .wk4 file and click on import.
You should get a window called... 123Worksheet Import..
Select import as Main document.
Using form as Import form.
Column format : using view
Click ok.

Once the import is done.. You can view the data in the view.
Now you can use the @DBcolumn based on this view...

If you want to do this using Lotus Script.. Check this question...


Good Luck

Expert Comment

ID: 12244251
The Lotus script in the link above basically shows you how to read data from an excel document and import into a form.

LVL 19

Expert Comment

ID: 12253006
If this is a one time activity and the document has fixed values, the above two suggestions are your best bet. If the contents of the attached document may vary, the above method wont help. In that case, use this approach.

(1) Detach the embedded file to a temproary location
(2) Read the range using OLE Automation and populate your list
(3) Or in lieu of step 2, connect to the excel sheet using ODBC and read the data dynamically. With this method, you can even use DBLookup/DBColumn on the excel sheet.

Read the topic "Accessing external databases through LS:DO using @functions" in the designer help for more info on this.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question