OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis     
 
Skip Navigation Links
All BooksExpand All Books
Origin HelpExpand Origin Help
Importing and Exporting DataExpand Importing and Exporting Data
Importing Data from a DatabaseExpand Importing Data from a Database

6.8 Importing Data from a Database

Video Image.png See more related video:Import Data from a Database

Origin provides two different interfaces for building database queries for importing:

  • SQL Editor: A simple SQL editor to create connection strings and SQL queries with an option to include LabTalk substitution.
  • Query Builder: A graphical query builder that helps users create complex queries. This is only available in 32 bit Origin.


Generally speaking, the SQL Editor is for users more fluent in SQL, while the Query Builder is helpful to those who are not familiar with SQL syntax.

Click the Open Query Builder or Open SQL Editor button on Database Access toolbar to start a new database connection. Or click File: Database Import: New... menu.

Topics covered in this section:
 

© OriginLab Corporation. All rights reserved.