Altova DatabaseSpy 2024 Professional Edition

Adding Data to the Database

Home Prev Top Next

The "ZooDB" database created so far has several tables, but it does not contain any data. This tutorial section shows you how to insert data in the database. Specifically, you will learn how to do the following:

 

Execute an existing SQL script that populates the database with data

Import data from a CSV file

Import data from an XML file

Create a new SQL INSERT script

Add new records manually

© 2017-2023 Altova GmbH