Data From Database

Import from Database function is used to get data from database.

SheetKraft contains the Data From Database option which can be accessed by the Import From Button present in the SheetKraft Toolbar ( See figure)

The data can be imported from a particular table of the database. Or a Stored Procedure or Manual Query can be used to retrieve data from database.

Case 1: Basic Example

The following guidelines describe how data can be imported from a particular table using Data From Database.

Step 1

Click on the Import From Button and select the Database option to open this dialogue box.

Step 2

Click on the browse button next to Connection, to configure the database connection. If the Configuration File is already setup as explained in Desktop & Server Configurations, then this step can be skipped.

A window for configuring connection appears. Configure the connection as shown in Step 4 of Export to Database.

Step 3

After entering the connection settings, select Table option.

Select the table name by clicking on the browse button next to the Table Name.

The database tables are listed in the format <SchemaName>.<TableName>.

Step 4

After selecting the database table, the data in the database table will be loaded.

Select the required columns in the output by checking on the checkbox corresponding to each column. The columns can be reordered by dragging the headers.

Step 5

The number of data rows retrieved from the database can be limited bt checking Max rows and entering the required number in the corresponding field.

Step 6

To get filtered/sorted data, click Filter/Sort and follow the steps given in Filter/Sort. Click Next to get the data without filtering or sorting.

You will be asked where to save the result. To save the data in the Existing WorkSheet, you can input the index of the starting cell where you want to copy the data. Or you can save the data in a New Worksheet.