User Tools

Site Tools


faq:odbc_part_load

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
faq:odbc_part_load [2016/11/02 14:35 (8 years ago)] clifffaq:odbc_part_load [2017/03/01 16:36 (7 years ago)] (current) – [loading MS Excel multi-line Comments] sjackson
Line 34: Line 34:
  
 {{faq:odbc-5.jpg|}} {{faq:odbc-5.jpg|}}
 +
 +===== 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 ====== ====== Alternate Instructions for 64 bit versions of Excel ======
faq/odbc_part_load.txt · Last modified: 2017/03/01 16:36 (7 years ago) by sjackson