CSV Files (Tools/APIs)
Work with CSV (comma-separated values) data sources.
Background Information
CSV (comma-separated values) is a simple, common format for data. For example, you can export to a .csv file from Microsoft Excel.
Available Tools
LOAD DATA SQL command
Load from CSV files into SQL tables using only InterSystems SQL. For more details, see LOAD DATA.
Record Mapper
Map CSV data into a production. For more details, see Using the Record Mapper.
Interactive CSV Import/Export
Import/export SQL data to or from a CSV file interactively by using the Management Portal. Use this option if you need to import or export data a single time. For more details, see Importing and Exporting SQL Data.
