I have tested with pubs database using the table name
Exec IMPEXPFROMDB ‘C:\EXP\export.txt’, ‘OUT’, ‘Employee’
A file will be created under EXP directory in the server as
export.txt in which the data will be copied. The file will be created in the
server (where Sqlserver runs) not in the client.