Excel hard return import into SQL

DJN 1 Reputation point
2022-09-12T13:07:32.783+00:00

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.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,479 questions
0 comments No comments
{count} votes