Introduction
Knowing the methods of importing and exporting data to and from Excel is very useful and will come in handy more than once in your work as a BA.
Use Notepad to create a file with the following data:
Letter, Item, Number, Date
A,apple,12,Feb 12
B,Betty,13,Feb 13
C,cat,14,Feb 14
D,dog,20
Save the data with the file name: mydata.txt
Exercise 1
Perform the following steps:
Open Excel.
Open option “Import text”
Specify the “txt” file you created above.
Follow the “data import wizard” steps to create an Excel spreadsheet containing the data in the txt file.
Additional Questions
Explain in general terms what is the point here. [Answer: You are “transferring” data to Excel from another application, using a simple data transfer format.]
What is a more sophisticated example of this general process. [Answer: Transferring data using “XML” format]