Briefly explain the process for configuring MySQL for importing Excel 2013 spreadsheet data into a SQL Server table, then discuss the import process using the MySQL for Excel Add-In
What will be an ideal response?
Using the MySQL installer, select "MySQL for Excel" that will install the MySQL for Excel Add-In. When Excel is launched, the add-in will appear on the DATA tab in the Excel 2013 ribbon as a button. Click on the button to launch the "Open a MySQL Connection" pane. Double-click the appropriate Local Connection link and enter the password. Select the database schema name, select the sheet with the data, and be sure to highlight the entire data range then click "Export Excel Data to New Table." Set the desired table characteristics such as the new table name, primary key, datatype and NULL/NOT NULL. Then click the "Export Data" button to populate the table. Click OK then Close to finish the process. The imported table does not have to be normalized, so adjustments may have to be made.
You might also like to view...
Metro Arcade sells tickets at $25 per person as a one-day entrance fee
Variable costs are $11 per person, and fixed costs are $52,500 per month. Assume that Metro increases variable costs from $11 to $14 per person. Compute the new breakeven point in tickets and in sales dollars. What will be an ideal response
If a business wants to maintain growth in a maturing industry, which of the following should be considered?
a. Moving operations offshore b. Reducing the workforce c. Product diversification d. Purchasing new equipment