How to do it...

Let's begin with importing data using Studio first and then we will move on to SQLA. The following DDL was used to create the table in the new database. Now load the data from the external file. The following steps allow you to do so:

1. Go to data explorer. 
2. Search for the database under which the required table is located:

1. Explore the database.

1. Right-click on the table, Name | Data | Load Data:

1. The Wizard will come up; select the source as External File:

1. On the next screen, just browse to the CSV file you need to load the data from.
2. Once the data is loaded, you will get a success message. 
3. To verify the data, right-click on the table, Name | Data | Sample Data; a few rows will pop up, showing that the data has been loaded.