You are here: Programming Environments > Programming Environments > Excel

Using the Scantron OLE DB Provider with Excel

Scanned data can be imported into Microsoft® Excel (2007 or later) by using the Excel Data Connection Wizard. Previous versions of Excel do not include the Data Connection Wizard. To import data into an older version of Excel you must write a macro or program. For more information regarding Excel macros, see the Microsoft® Excel Help.

To import scanned data into Excel (2002 or later) via the Data Connection Wizard:

  1. On the Data menu, select Import External Data, then Import Data. The Select Data Source window is displayed.
  2. Click the New Source button to open the Data Connection Wizard.
  3. Select Other/Advanced from the list, then click Next. The Data Link Properties dialog is displayed. Select the Provider tab if it is not selected by default.
  4. Select Scantron OLE DB Provider for ScanTools Plus from the list, then click Next. The Connection Tab is displayed.
  5. Specify the data (*.dat), image (*.tif), application (*.sds.StxAppDef), or edit profile (*.$ep.StxEdtPrf) files you want to connect to. For more information on selecting data files, see Data Link Properties dialog - Connection Tab.
  6. After you specify your data file(s), Click OK to return to the Excel Data Connection Wizard. The Choose Data window is displayed. The Choose data window shows a list of document definitions to choose from.
  7. Select a document name to view and then click Next. The Finish window is displayed.
  8. Enter a name and description (optional) for the Data Connection (*.odc) file, the click Finish.
  9. Select where in Excel you want to display the data (Existing worksheet or New worksheet) and then click OK. The selected scanned data is displayed in an Excel worksheet.

NOTES:

Before saving, you can also edit the query by selecting the Edit Query button.

ScanTools and Data Services cannot access data files simultaneously:

 

 

See Help on Help for additional information on using this help file.

See Scantron Technical Support for additional information on technical support and training options.

See the ScanTools Suite System Requirements for further details on hardware and software requirements.

ScanTools is a suite of products; the specific information you want may appear in the help for a different module. If you don't find what you're looking for here, try one of the following:

  

Scantron Corporation

Customer Service (forms, products, and services):

1-800-SCANTRON (722-6876)

www.scantron.com

Technical Support:

1-800-445-3141

[email protected]

Copyright © 1998-2012 Scantron Corporation. All rights reserved. Use permitted only under license. www.scantron.com. No part of the Help or user guides may be reproduced in any form, or by any means, without express permission from Scantron Corporation.

LINKS TO THIRD PARTY SITES

This help system may contain links to third party websites ("Linked Sites"). The Linked Sites are not under the control of Scantron and Scantron is not responsible for the content of any Linked Site, including without limitation any link contained in a Linked Site or any changes or modifications to a Linked Site. Scantron is not responsible for web casting or any other form of transmission received from any Linked Site. Scantron provides Users with the ability to link the Assessment System to the Linked Sites as a convenience to you, and the inclusion of any link does not imply endorsement by Scantron of the Linked Site or any association with its operators.