How to insert data from CSV using sqlcmd?

user_15311549 0
Viewed 546

I can convert data database to .csv using sqlcmd syntax

sqlcmd -S ipdb -U sa -P "passwordsa" -d dbname -Q "select * from tabelname" -o "direktori/file.csv" -s"," -W -w 700

but how can I insert data from my .csv to table using sqlcmd syntax?

sqlcmd sql-server sql
1 Answers

Finally this problem solve. I Use Bulk Copy Data (BCP) syntax on Ubuntu 20.04

bcp Tablename in ~/filename.txt -S localhost -U sa -P <your_password> -d Databasename -c -t  ','
user_153115490
Related