This is a post on how to remove quotes from a CSV file using PowerShell. If your dealing with a large CSV file, running the Import-CSV cmdlet below will consume a lot of system resources (RAM mostly).
The Import Flat File feature within SQL Server Management Studio (SSMS) was introduced in December 2017 (14.0.17213.0). This is a streamlined version of the Import Data feature and it minimises the user intervention during a file import.
This post contains a script that will help count rows within multiple CSV files using PowerShell. If you have a directory containing CSV files, this demo will walk you through how to count the rows of all CSV files within a folder.
This post contains a guide on how to export data from a SQL Server database using SSMS. SSMS, SQL Server Management Studio, is the standard application that most people use to run queries for a Microsoft SQL Server Database.