Inserting New Worksheet

Inserting New Worksheet

You can add additional worksheets by clicking the plus button in the tab list, pressing Shift-F11, or using the Data, Insert Worksheet menu button.

DBEdit uses a single connection string per workbook created with a workbook.

So, you get the wizard that allows selecting a new object to get data only:

DBEdit Connection Wizard - Select Object for New Worksheet

In the next step, you can choose fields for tables and views or set parameters values for stored procedures, functions, and SQL-based objects.

For example:

DBEdit Connection Wizard - Edit Parameters

Here is a sample of an inserted stored procedure:

DBEdit - New Workbook - Procedure Sample

You can resize, hide, and freeze columns to get the required table look:

DBEdit - New Workbook - Formatted Table