To properly import a table from Microsoft Excel 2016,which of the following steps is not taken?
A) Use the SQL Server Import and Export Wizard to import data into a temporary table
B) Use an SQL Create Table statement to create the actual table
C) Use SQL Server to normalize the table
D) Use an SQL Insert statement to copy data from the temporary table to the actual table
E) Delete the temporary table from the database

Question

Quizplus · Accepted Answer

Normalizing the table is not a step in importing a table from Microsoft Excel 2016. The other steps listed - using the SQL Server Import and Export Wizard to import data into a temporary table, creating the actual table using a Create Table statement, copying data from the temporary table to the actual table using an Insert statement, and deleting the temporary table from the database - are all necessary steps in importing a table from Microsoft Excel 2016.

To Properly Import a Table from Microsoft Excel 2016,which of the Following