1 / 9

Importing Data from a Spreadsheet

Importing Data from a Spreadsheet. If you came to this presentation via a web browser, right-click and choose “F u ll Screen” before proceeding. Click mouse or press space bar to continue.

dianne
Télécharger la présentation

Importing Data from a Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Importing Data from a Spreadsheet If you came to this presentation via a web browser, right-click and choose “Full Screen” before proceeding. Click mouse or press space bar to continue. • This presentation was prepared by Professor Steve Ross, with the advice of other MIS Faculty, for use in MIS Classes at Western Washington University. Please contact Dr. Ross for permission to use in other settings..

  2. Introductory Slides • See “ImportingData - Overview and Preparation of the Database” for an overview, for creating a database and for basic preparation steps. • These slides introduce a basic approach to using the Import Wizard provided with SQL Server Management Studio.

  3. Import the Data • Import the data • Right-click Database name; choose Tasks; choose Import Data…; click Next > on the splash screen • Choose the Data Source (Microsoft Excel) and browse to locate the file  • Note thesesettings

  4. Destination • Click Next until you reach the window with “Sister Cities$” (illustrated on the next slide)

  5. Note: in this example • “tblCity” is the entire Excel workbook. • “Sister Cities$” refers to a tab in the workbook. • Check “Sister Cities$” as shown above. • Click Edit Mappings

  6. Under “Edit Mappings”, choose… • int as the data type for Population • nvarchar with size max for Description • Click OK to close Edit Mappings. • Click to the last window, then Finish

  7. Continue through the import wizard  until you reach the last window. • Note: along the way you will encounter the yellow warning symbol that you see below. Ignore it and keep going to the last window)

  8. Click the Finish button. • The importation should complete without problem. • Close the wizard. • The new table in your database will be named ‘Sister Cities$’. • Remove any spaces or special character symbols, e.g. $ or quotation marks..

  9. Verify the Import Results • Inspect the table (right-click table name, choose Select Top 1000 Rows) • Data in expected columns • Numeric data format, ensure no loss • Character data, check for truncation

More Related