How to use .net to import txt files to a database

nonameisname

How do I import a txt file to a database using vb.net?

Each field in my txt document is separated by spaces.

Thank you ~

nonameisname

Waiting for reply online ~

ydnh2222

Can't read and write

ghosthzz

Can read text into a DataTable and write to the database

heatheat

See if you can pass ODBC.

stephensun

Are the fields in txt rules
If this happens.
Read txt file
Use split('') to divide into arrays
Pay each parameter separately
Then update to the database

zhenyumen

I read and write no matter what

choke00

If it is a sql server, I suggest you write a stored procedure to encapsulate bcp, you can call this procedure with a program, and the speed is very fast, so you can also do secondary processing in the database