Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm importing an Excel file into SQL. I have a two line field with a formula =Q2&CHAR(10)&""&R2. It takes two fields and combines into one field, before importing. Is there a way to import the combined field into SQL so the field shows two lines, instead of one line?
For example, Excel shows:
DAVE
TEST
Import shows as:
DAVE TEST
I would like the SQL memo field to show as two lines.
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.