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

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.