BCP bulk Export Import datasheet entry

Export:
BCP data table queryout Export address-c-u user name-p user password-s database address

Cases:
bcp persons queryout C:\Users\Administrator\De sktop\bcp\persons.bcp-c-uroot-proot-s127.0.0.1

You can also join a database statement to select several of these data exports, for example:

BCP "SELECT * from persons where name = ' Simple '" queryout c:\Users\Administrator\Desktop\bcp\persons.bcp-c-uroot-proot -s127.0.0.1

Import:
BCP data table in import address-c-u user name-p user password-s database address

Cases:
bcp persons in C:\Users\Administrator\De sktop\bcp\persons.bcp-c-uroot-proot-s127.0.0.1

Note: This is a command-line statement, so to open the command line Input statement execution, press the shortcut key win+r input cmd run and then enter the above statement to run it