Excel Import Script Using OLE and Notes Client and Compatibility of Data Exchange

Mindwatering Incorporated

Author: Tripp W Black

Created: 11/12/2003 at 08:21 PM

 

Category:
Notes Developer Tips
LotusScript

External OLE Import from Excel Example:
Excel Import Sample.txt


Note: Embedded OLE issue has been discovered w/Notes 8.5 and Office 2003/2007.
See data FX (exchange) issue compatibility chart.
(Last updated 2016/01/06 thanks to a client and an IBM tech)

OS
Bit
Office Rel.
Notes Rel
MS Office
MS Excel
Win XP
32
2003
8.5.2 -
8.5.3
-
No Error
Win XP
32
2007
8.5.2 -
8.5.3
-
No Error
Win XP
32
2007
9.0.1
-
No Error
Win 7
32
2010
8.5.2 -
8.5.3
-
No Error
Win 7
64
2010
8.5.2 -
8.5.3
-
Error
Win 7
64
2010
8.5.3FP6 S HF577_32
-
No Error
Win 7
32
2010
9.0
Error
No Error
Win 7
32
2010
9.0.1
Error
No Error
Win 7
64
2010
9.0
No Error
Error
Win 7
64
2010
9.0.1
No Error
Error
Win 7
32
2013
9.0
No Error
No Error
Win 7
32
2013
9.0.1
No Error
No Error
Win 7
64
2013
9.0
No Error
No Error
Win 7
64
2013
9.0.1
No Error
No Error


previous page