Sunday, September 22, 2013

How to Import Data With Excel 2007


1. Log on to your computer and open the Microsoft Excel spreadsheet into which you want to export the data. Click the 'Microsoft Office' button.
2. Click 'Open' and choose the type of file you wish to export. Double-click the file you wish to import.
3. Choose whether the file to be imported is a delimited or fixed-width file. With a delimited file, each field is separated by a particular character, generally a comma, a semicolon or a colon. This type of file is most appropriate for files where each record contains data of varying lengths. A fixed-width file is most appropriate for files where each record is the same size.
4. Review the field names Excel assigns to each field. Type a new name if you wish, then click 'Next.' Click 'Finish' to complete the import process.

Blogger news