We help IT Professionals succeed at work.

Excel 2010 data import to Notes

jkee54
jkee54 used Ask the Experts™
on
I need a way to take an Excel 2010 document, saved as a .xls  file and import it into Notes.  Excel 2010 does not support the .wk* extensions.  I have exported from Notes to Excel using lotusscript, but I don't know how to do it in reverse, especially with Excel 2010 which is new to me.

This is a production problem that I have to fix asap.  help!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

can you get your hands on a copy of Excel 2003? That version still supports saving to .wk? format.

cheers, teylyn
Groupware Consultant
Commented:
Notes supports csv, see this tip: http://searchdomino.techtarget.com/tip/Importing-a-CSV-file-into-view

Or use the more complex way, i.e. via the COM interface: http://www.empachal.com/pf_cable/blog.nsf/htdocs/ZIMN-7M9L5W

Author

Commented:
The .csv solution worked like a charm!  Thanks so much!