Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Skip to search results
Business Intelligence with Excel and SharePoint
Connect to (import) an OLAP database
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...
Use the Connection Properties dialog box to control various settings for connections to external data sources, and to use, reuse, or switch connection files. ...
Exchange (copy, import, export) data between Excel and Access
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...
Import or export text (.txt or .csv) files
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.
Plan external data connections for Excel Services
Refresh connected (imported) data
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...
Use Microsoft Query to retrieve external data
You can use Microsoft Query to retrieve data from external sources.