sql server - Import .txt file to SQL database using VB.NET -

sql server - Import .txt file to SQL database using VB.NET -

i have sql database (local using vb.net) has table 76 columns. info needs set columns in form of plain delimited text file. need build vb.net application allow me import text file table in database under appropriate columns. there way can this?

i'm new vb.net. can help me out code?

thank you! kamall

if have comma-separated values:

bulk insert tablename 'c:\myfile.txt' (fieldterminator = ',', rowterminator = '\n') go

for tab-separated values use:

bulk insert tablename 'c:\myfile.txt' (fieldterminator = ',', rowterminator = '\n') go

sql sql-server vb.net