Abstract
Excel data can come from a variety of sources. If the data you want to analyze is available in another file or electronic format, you may be able to import it directly into Excel. For example, perhaps you want to view a subset of data from a large database in Excel, or you want to evaluate some of the enormous wealth of raw data that is available on the Web. Data sources that can be used with Excel include text files, Microsoft Access, Microsoft SQL Server Analysis Services (for OLAP databases), Microsoft Visual FoxPro, dBASE, Oracle, and Paradox. Excel 2007 has simplified the process of obtaining data from other sources and of managing the connections to these sources with most of the relevant commands available on the Data tab of the Ribbon. This chapter will show you how to import data from other sources like Access or the Web so that you can work with it in Excel.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2007 Helen Dixon
About this chapter
Cite this chapter
(2007). Getting Data from External Sources. In: Excel 2007. Apress. https://doi.org/10.1007/978-1-4302-0389-6_15
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0389-6_15
Publisher Name: Apress
Print ISBN: 978-1-59059-798-9
Online ISBN: 978-1-4302-0389-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)