Excel Spreadsheet

Installing the Connector

First, check to see if the connectors for Excel are already installed on your system:

1. Open Microsoft Word with AutoTag installed.
2. Click the "Data Sources" icon.
3. Click "Add".
4. For the vendor, look for "Excel (OleDb)". If this isn't one of your vendor options, you do not have the connector and will need to install it

There are two different installers, depending on the version of Office you are using.

• If you have Office 2000 through Office 2007 or Office 2010 x86:
  • AccessDatabaseEngine.exe
• If you have Office 2010 x64:
  • AccessDatabaseEngine_x64.exe

Both can be downloaded from Microsoft here.

After you've downloaded the connector, you can move to the next step:

Connecting to your Excel datasource

Open Microsoft Word with AutoTag installed.

1. Click the 'Data Sources' icon.
2. Click 'Add'.
3. For the vendor, choose 'Excel (OleDb)'.
4. Click on the downward arrow next to 'Provider'. (See image above)
5. Select the correct driver depending on the type of Excel file.
6. For server, click the 'Browse' button and select your Excel file.
7. Click the 'Test' button to ensure you can connect.
8. Click 'OK'.