Archives: March 2012
Importing data from Excel – using INSERT statements
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However, when the data is simple and limited I avoid using it (too lazy to click through 6 screens… ) instead I generate INSERT statements using CONCATENATE function in Excel… Read more
6 comments, 3,036 reads
Posted in SQL and Me on 29 March 2012
Exporting data to CSV file using SQLCMD/BCP
When it comes to exporting data there are different options available in SQL Server, such as SQL Server Integration Services, Generating Insert Scripts, BCP, Import and Export Wizard and SQLCMD.
When it comes to exporting data as CSV file, BCP and SQLCMD are the easiest methods.… Read more
3 comments, 4,287 reads
Posted in SQL and Me on 27 March 2012