Overview
This example inserts data into a database from an array in LabVIEW using the Database Connectivity Toolkit.
Description
When writing data to a database, you may have the data in array format, with each array element corresponding to a different column of the database. This example allows to easily write array data to your database: each array element will be written to a different column in a desired database table.
Steps to Implement or Execute Code
- Select the UDL file for the connection information to the desired database. You can run this example using LabVIEW.udl connection file for the LabVIEW.mdb database provided with Database Connectivity Toolkit examples. To create a new database instead, you may also consider DATABASE CREATION PROCEDURE.pdf available here
- Set the desired Table Name and Columns
- Write the data to insert into the Database in Array Input Data control
- Run the VI
Requirements
- LabVIEW 2012 (or compatible)
- Database Connectivity Toolkit 2012 (or compatible)
Additional Information or References
VI Block Diagram
**This document has been updated to meet the current required format for the NI Code Exchange.**