Leading the way in Microsoft Office Development

Reference Articles - 2007

2007: Connect to (Import) external data

2007: Connection properties

2007: Create edit and manage connections to external data

2007: Data sources that you can access

2007: Exchange (copy import export) data between Excel and Access

2007: Import data from a SharePoint list

2007: Refresh connected (imported) data

2007: Remove the data connection from an external data range

2007: Use Microsoft Query to retrieve external data

Reference Articles - 2003

2003: About OLAP source data in PivotTable and PivotChart reports

2003: About automatic font switching

2003: About exchanging data between Excel and Access

2003: About importing data

2003: About installing OLAP providers

2003: About installing an ODBC driver

2003: About offline cube files

2003: About sharing data connections

2003: Change how an imported text file looks

2003: Change the name of an external data range

2003: Change the query for an external data range

2003: Copy Excel data and charts to Word or PowerPoint

2003: Copy a Word table into Excel

2003: Copy an external data range and its underlying query

2003: Copy formulas when an external data range expands

2003: Create a report template for importing data

2003: Create an OLAP query file to connect to an OLAP database

2003: Create an offline cube file from an OLAP server database

2003: Creating data cubes using Excel and text files

2003: Customize a parameter query

2003: Customize field names in an external data range

2003: DELETE About data entry forms

2003: Data sources you can access

2003: Delete an external data range

2003: Delete an offline cube file

2003: Find an external data range

2003: Freeze data in an external data range

2003: From Access to Excel: Quick financial charts

2003: Import a text file

2003: Import financial data into Excel from various sources

2003: Import or connect to data

2003: Include different data in an offline cube file

2003: Print labels by using Excel data in a Word mail merge

2003: Reconnect to an OLAP server

2003: Refresh an offline cube file

2003: Refresh imported data

2003: Run a query in the background or while you wait

2003: Specify how new data is added to an external data range

2003: Troubleshoot OLAP cubes

2003: Troubleshoot importing data

2003: Using Access or Excel to manage your data

2003: Work with OLAP data offline

Reference Articles - 2002

2002: Design Access databases with normal forms and Excel

2002: Link data from Excel to Access with AccessLinks

Reference Articles - 2000

2000: Change how separators are displayed when importing text files

2000: Get and analyze data from the Web in Excel

2000: Importing text files with 257 or more columns

2000: Link Excel and Word to store data more efficiently