• Directly import images stored inside the database as pictures in worksheet cells
• Protect imported data from editing, to ensure data integrity, 
• @IPDB(Database Import) and @IPDC(Data Connector) to control the protection mode for imported range.
  • 0 - no protection
  • 1 - protected, except reorder
  • 2 - protected
• @DBSV to control whether to show Views in table list on SQL Editor dialog or not. Default is 0 to not show.
• Support Exclude Imported Data when saving as OPJU/OGWU for Database Import.
• Improved Ease of Use and performance

In previous versions, import database by ODBC is slower than ADO, and cannot import large dataset. Now this has been improved in Origin 2020.

Setting @ODBCA = 0 (Default), then you should be able to import large dataset now.

Also, the performance of ODBC should be faster than ADO method now.

Also, when importing using Microsoft OLE DB Provider for ODBC for database connection, Origin will use ODBC by default now. It used to use ADO by default even for ODBC.