Importing Scanned Data into SQL Server

You can import data into Microsoft® SQL Server with the Data Transformation Services (DTS) wizard.

Use the SQL Server Enterprise Manager to create a new database in SQL Server. For help on creating a new database, see the SQL Server Help.

From the Windows Start Menu, choose Programs>SQL Server>Import and Export Data. The DTS Import/Export wizard is displayed.

From the Data Source list, select the Scantron OLE DB Provider.

Click Properties. The Data Link dialog appears.

Enter the paths to the data, application, image, or edit profile files and then click Next. See Configuring a Data Link for the Scantron OLE DB Provider.

Select the database you created in step 1 then click Next.

Select Copy Tables and Viewsthen click Next. The tables and views available in your data file (*.dat) are displayed as a list.

Select one or more tables to copy data from then click Next.

To run the query, click Next.

When the progress bar has completed, click Done. The data is imported into the database.

NOTE: ScanToolsand Data Services cannot access data files simultaneously:

If ScanTools is using a file for scanning, viewing, or modifying, Data Services cannot access the file at all.
If Data Services is using a file, ScanTools cannot use it for scanning, viewing, or modifying.

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:

ScanTools Plus Scanning Module WebHelp

(includes Real-Time Character Recognition utilizing NestorReader Help)
ScanTools Plus Application Designer Module WebHelp

(includes Real-Time Character Recognition utilizing NestorReader Help)
ScanTools Plus Download Utility WebHelp
ScanTools Plus User Exits WebHelp
ScanTools Plus Legacy Reference Information WebHelp

(a previous version of ScanTools Plus Help that may help power users)
ScanTools Plus Link SDK WebHelp
(API Help for developers)

Scantron Corporation

Customer Service (forms, products, and services):

1-800-SCANTRON (722-6876)

www.scantron.com

Technical Support:

1-800-445-3141

support@scantron.com

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.