1-866-245-5224 sales@keystonelearning.com

Excel 2003: Importing Data to Excel

Excel 2003: Importing Data to Excel

Let’s start with the art of Importing – or, getting data stored in other places into Excel for analysis. One of the main benefits to importing is you can maintain a connection to the original data source. This means, when the original source updates, your Excel spreadsheet will update, too.

 Importing from Microsoft Access

     
  1. Choose Data: Import External Data: Import Data from the Menu bar
     

Figure 15. Select Data Source Dialog Box

   2.      Navigate to the folder that contains your Access database

   3.      Select the Access database and click Open

 

 

Figure 16. Import Data Dialog Box

 

   4.      Select the location for the data you are importing

   5.      Click OK

Importing from a Text File

There are two text file types you can import into Excel: .txt and .csv. A .txt file is a delimited text file that typically has the columns of data separated with the TAB character. A .csv file simply indicates a file in which the columns of data are separated by commas, hence the name: comma separated values.

Importing from a .txt File
     
  1. Choose File: Open from the Menu bar
     
  2.  
  3. In the Files of type box, select Text Files
     
  4.  
  5. Double-click the text file you want to open
     
  6.  
  7. Follow the instructions in the Import Text Wizard
     
Importing from a .csv File
     
  1. Choose File: Open from the Menu bar
     
  2.  
  3. In the Files of type box, select Text Files
     
  4.  
  5. Double-click the comma separated value file you want to open