HI,
i want to export data from a sql table to a csv file with a the name of each colunms in the csv file
i use this script
bcp [databasename.owner.table ]out [path.csv] -t, -c -Uuser -Ppass -Sservername
i want to put each column name in my csv file.
Sorry for my english, i'm not fluency in english
Thanks,
PatrickUse OSQL instead.|||Use DTS, you can export the data to a CSV file and I believe there is an option to include headers (column headers) into the CSV file.
没有评论:
发表评论