SQL Import method, seen on the internet

-------This is a new table, ready to import the table

CREATE TABLE csvtable (
Name NVARCHAR (MAX),
Email NVARCHAR (MAX),
Area NVARCHAR (MAX)
)

----------Insert data from D:\csv.txt, each data delimiter is | The delimiter for each piece of data is;----------

BULK INSERT csvtable
From ' D:\csv.txt '
With (
FieldTerminator = ' | ',
Rowterminator = '; '
)

--------Query the content you import----
SELECT * from Csvtable

Someone once told me another way, is from the data interface upside down data, the method of depositing the database, but also interception, but his method is written by himself

Use Left (' String ' indexof (string)) to intercept this 1.1-point loop recursively.

SQL Import method, seen on the internet