Differences

This shows you the differences between two versions of the page.

--- faq:odbc_part_load [2017/03/01 16:24 (7 years ago)] – [Loading parts via MS Excel using ODBC] sjackson
+++ faq:odbc_part_load [2017/03/01 16:36 (7 years ago)] (current) – [loading MS Excel multi-line Comments] sjackson
@@ Line 35: / Line 35: @@
 {{faq:odbc-5.jpg|}}
-===== loading MS Excel multi-line Comments =====
+===== Loading MS Excel Multi-line Comments =====
+When using Excel to enter a multi-line comment in an Excel cell, you can press Alt-Enter to get a new line.
+Then, the comment can be continued on the next line.
+**You need to use this ODBC load to data load a sheet with multi-line comments.  A CSV multi-line comment data load will give you garbage.**
+You can create an amalgamation of Excel cells to create a multi-line comment cell before importing.
+<note>For example, you may have an Excel sheet with a Note1, Note2, and Note3 column.
+You can merge these into a 4th column before data loading by first using a formula in Excel.
+If B2, C2, and D2 contained Note1, Note2, and Note3, in E2 enter this formula:
+=B2 & CHAR(10) & C2 & CHAR(10) & D2
+The CHAR(10) character acts a newline character, which System Five will recognize as a new line in the comment box.</note>
 ====== Alternate Instructions for 64 bit versions of Excel ======