Database Management White Papers

Quickly import data into Excel with these techniques

Overview 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

Further White Paper Details
PublisherTechRepublic File FormatPDF
Date PublishedOctober 2005 Downloads6387
FormatDownloads   
Topics
  • Featured White Papers
Thin clients switch on digitally excluded

Thin clients switch on digitally excluded

Case study: Digital inclusion project tackles social exclusion in Liverpool more

Renault goes multilingual

Renault goes multilingual

Case study: Translation tech turns docs into 23 languages… more


Quick Sitemap Links: