Importing and Exporting Data
Excel enables you to create a list using data from a text file; you can also save a list to a text file. You import and export text files when you want to share lists between programs, such as mailing-list management software and database programs that cannot read Excel 2000/2002 worksheet files.
Note
In some cases, you can extract data directly from a database without having to convert it to a file. See the following section for details on how to connect to an external database.
To import a text file as a list, first position the insertion point in the cell where you want the data to appear. Make sure that no data appears below or to the right of the location that you select, or it could be overwritten. Then follow ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
