Importing Data into SQL Server – Using the Import Export Wizard
Today begins the series on importing data into SQL Server 2005/2008 using the various built in tools. With SQL Server, there are several ways of getting your data from one place to another. Today, we will focus on using the wizard from SQL Server Management Studio. Before we begin, I am using a simple database called testdb. I am also using a country code file found at http://www.andrewpatton.com/countrylist.html. The file contains the 2 and 3 character ISO 3166 Country Code abbreviations, which we will use in our sample. The CSV file as seen in Excel 2007 Here is the script … Continue reading Importing Data into SQL Server – Using the Import Export Wizard