faq:odbc_part_load
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
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: | {{faq: | ||
- | ===== loading | + | ===== Loading |
+ | 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. | ||
+ | |||
+ | You can create an amalgamation of Excel cells to create a multi-line comment cell before importing. | ||
+ | < | ||
+ | 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.</ | ||
====== 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