See Also:
Office.com results
Connect to (import) an OLAP database
Article Show All Hide All You can use an Office Data Connection (.odc) file to connect to an Online Analytical Processing (OLAP) database. On the Data tab, in the Get E...
Excel 2007
Connection properties
Article Use the Connection Properties dialog box to control various settings for connections to external data sources, and to use, reuse, or switch connection files. ...
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
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
Use Microsoft Query to retrieve external data
Article You can use Microsoft Query to retrieve data from external sources.
Excel 2007