Export a SQL table to CSV file (Comma Separated Value) or any other file is something very common and easy to do, but still I’ve seen people having some common mistakes.
Here is the basic way to export a table to a CSV file.
This process is very similar if you want to export it to any other file extension like Excel, Access, txt, or more…
Step 1: Right click the database name and navigate to Task -> Export Data
Export step 1