Aug 26, 2020 · On the left-side, select your database. Click on Import from the top set of tabs. Click on the Browse button next to "Location of the text file." Browse to your local database file and click Open. How to Export SQL Server Data to CSV by using SQL Server Management Studio. However, when the primary database MDF file is corrupted, you have to use a professional MS SQL repair tool to fix the problem at first, then you can continue exporting the database.
In Interactive SQL, connect to the SQL Anywhere database. Execute an OUTPUT statement with the clauses FORMAT TEXT, QUOTE '"', and WITH COLUMN NAMES to create a comma-delimited format with the column names in the first line of the file. String values will be enclosed with quotation marks.