Memo field in a table

[SFC]

I'm using Access 2010 to import CSV text file into a table. One of the values in the CSV has multiple lines, when this gets imported into the table in Access (as a memo field) it treats each line of text as a seperate row. Is it possible to have Access import a multiline CSV as one value?

For example one of the Delimited fields contains this:



Line of text 1
Line of text 2
Line of text 3

Can this be kept to one row and not three rows?

Any imput is greatle appreciated,
Steve

[ajetrumpet]

try: http://www.google.com/#hl=en&expIds=...0cfd04ba3c5cf9

[SFC]

Thanky you for your input