Skip to search results
PRODUCT
Office.com results
Connect to (Import) external data
Article The main benefit of connecting to external data is that you can periodically analyze this data in Microsoft Office Excel without repeatedly copying the data, wh...
Excel 2007
Microsoft Excel Blog: Manipulating and massaging data in Excel
Article The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel pro...
Excel 2007
Manage external data ranges and their properties
Article You can change the properties of an external data range to control data that has been imported into a worksheet through a connection to an external data source....
Excel 2007
Connect to (import) SQL Server data
Article You can use an Office Data Connection (.odc) file to connect to a Microsoft SQL Server database from a Microsoft Office Excel 2007 file. SQL Server is a full-fe...
Excel 2007
Import data from a SharePoint list
Article You can import and analyze data from a list on a Windows SharePoint Services 3.0 or Windows SharePoint Services 2.0 site. For example, you can import a parts ...
Excel 2007
Use Microsoft Query to retrieve external data
Article You can use Microsoft Query to retrieve data from external sources.
Excel 2007
Get external data from a Web page
Article You can create or run a Web query to retrieve text or data from a Web page. Web pages often contain information that is perfect for analysis in Excel. Dependi...
Excel 2007
Text Import Wizard
Article You can use Microsoft Office Excel to import data from a text file into a worksheet. The Text Import Wizard examines the text file that you are importing and he...
Excel 2007
Top ten ways to clean your data
Article Show All Hide All Misspelled words, stubborn trailing spaces, unwanted prefixes, improper cases, and nonprinting characters make a bad first impression. And tha...
Excel 2007
Refresh connected (imported) data
Article A cell range, Excel table, PivotTable report, PivotChart report, text file, and Web query can all be connected to an external data source. You can refresh the d...
Excel 2007
Microsoft Excel Blog: Append multiple text files into a worksheet without code
Article The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel pro...
Excel 2007
Exchange (copy, import, export) data between Excel and Access
Article There are several ways to exchange data between Microsoft Office Access and Microsoft Office Excel. To bring data into Excel from Access, you can copy data from...
Excel 2007
Import or export text (.txt or .csv) files
Article To import a text file, you can open the file or import the text file as an external data range. To export a text file, use the Save As command.
Excel 2007
Getting External Data
Article Nick Hogde's Excel Blog One of the most visited parts of Nick Hodge's Web site is the part on external data. In this article, you will learn about easy ways to ...
Excel 2007
Customize a parameter query
Article You can customize a Microsoft Query or Web query parameter query by changing the prompt, by using data from a cell as the prompt, or by using a constant. For ...
Excel 2007
Overview of connecting (importing) data
Article This reference article discusses importing and connecting data. You will learn about tasks like importing, updating, securing, and managing data.
Excel 2007
Create, edit, and manage connections to external data
Article You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the W...
Excel 2007
Didn't find what you were looking for?Search all of Office.com