using a text field

At least in Oracle, you can do statements like

INSERT INTO MY_TABLE

VALUES

('A multi

line

text')

You need to be careful with the typical end-of-line issues (CRLF or just LF), though.

you can create a table with text type column and load data via sql command INSERT INTO teste-table VALUES (' text text text or via BUCKET INSERT command http://www.sqlservergeeks.com/blogs/piyush.bajaj.2007/sql-server-bi/310/sql-server-%E2%80%93-bulk-insert Example:

BULK INSERT [teste-table]

from 'c:\Users\user\teste-table.data.latin1'

WITH

(FIELDTERMINATOR ='|',

ROWTERMINATOR ='\n',

CODEPAGE='ACP',

KEEPIDENTITY

)

GO

(SQL Server) If the text has apostrophe, should be treated, otherwise errors will occur