Quickly import data into Excel with these techniques

This sample chapter, taken from Managing Data with Excel, highlights a couple ways to get data from other applications into an Excel worksheet.

Learn a couple ways that you can import data into Microsoft Excel.

This sample chapter, taken from Managing Data with Excel, discusses ways to get data from other applications into an Excel worksheet. The chapter covers the following topics:

• How to get external data into a worksheet without writing a line of code
• How to update, or refresh, the external data to keep your worksheet current, both by setting options and by using VBA code
• How to use Microsoft Query to guide you through the process of pointing queries at the data source

Title: Managing Data with Excel
ISBN: 0789731002
Published: May, 2004
Author: Conrad Carlberg
Chapter: Chapter 4: Importing Data: An Overview
Published by Que