6.9 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: