Importing from an External Database into the Datasheet

RockWorks | Utilities | File | Import | External Database

The program is used to import into the RockWorks datasheet information from a database exported from an external source. The process involves defining the data type and selecting the data file to be imported, mapping the import fields to the datasheet columns, and importing the data.

Introduction
Step-by-Step Summary

Introduction

This program can be used to import data from a selected table in an external database into the RockWorks Utilities datasheet. Windows supplies database connection drivers for MS Access, MS SQL Server, Oracle, and most ODBC (Open Database Connectivity) drivers.

Acronyms

• ODBC – Open Database Connectivity
• MS – Microsoft
• OLEDB – Object Linking and Embedding, Database
• SQL – Structured Query Language
• UDL – Universal Data Link
• (see http://msdn2.microsoft.com/en-us/library/e38h511e(vs.71).aspx)

The following are the steps to import from an external database.

Step-by-Step Summary

• Step 1: Select the Data Source
• Step 2: Select the Data to Import

  Back to Importing Data

RockWare home page