You can use the SQL Server Import and Export Wizard, BCP utility, or custom T-SQL queries to export table data into CSV files. However, exporting multiple tables may require configuring separate exports or writing additional scripts, depending on your database structure and requirements.

If you also need to extract data from an inaccessible or corrupted database, SysTools SQL Server Recovery Tool is worth considering. It helps recover SQL Server database data from MDF files and supports exporting recovered data into SQL scripts and other supported destinations. For direct CSV exports, check the specific tool's available export options before choosing it.

For regular exports from a healthy database, native SQL Server utilities are a practical choice. If database recovery is also part of the requirement, SysTools can provide a more specialized solution before you proceed with data extraction.