Once you have selected the table to receive the data in the Data Source Explorer, You can specify the type of data import you want performed.
You must select External File as the Source Type to launch the Load Data Wizard.
After the Load Data Wizard opens, specify the name, path, and external file type of the source file. Use the drop-down lists to select the correct information.