The SaveToDB add-in places the SaveToDB tab to the Excel ribbon and looks like this: The add-in allows creating custom views for database queries that significantly reduces user requests to database developers. Use views as data sources for stored procedure parameter controls.Use configuration views to filter database objects available to users.Use translation views to translate database object names to a user language.Use translation views to translate Excel table column names to a user language dynamically.Use stored procedures as Excel event handlers to implement the drill-down feature.Using server-side configuration views and stored procedures you can: You can change the values of stored procedure query using the ribbon.You can change the query of a data table using the ribbon Query List.The add-in adds the following features to Microsoft Excel right after install:

The SaveToDB add-in allows connecting to stored procedures and changing a group of connections strings of existing Excel data tables. In this article, we will discuss SaveToDB Add-In for Microsoft Excel. You can always ask an expert in the Excel Tech Community or get support in the Answers community.SQL Server Import to Excel using Excel Add-Ins Link a cell to display selected list value.Ĭlick the box next to ListFillRange and type the cell range for the list.Ĭhange the number of list items displayedĬlick the ListRows box and type the number of items to be displayed.Ĭlose the Property box and click Designer Mode.Īfter you complete the formatting, you can right-click the column that has the list and pick Hide. button and pick font type, size, or style.Ĭlick ForeColor > the down arrow > Pallet, and then pick a color. Here's how to set properties for the combo box in this picture:Ĭlick BackColor > the down arrow > Pallet, and then pick a color.Ĭlick Font > the. Right-click the combo box and pick Properties, click Alphabetic, and change any property setting that you want. If you type a number that's less than the number of items in your list, a scroll bar is displayed. For example, if your list has 10 items and you don't want to scroll you can change the default number to 10.

If the following formula, is typed into cell C1: =INDEX(A1:A5,B1), when we select the item 'Sorbet' is displayed in C1.ĭrop-down lines: The number of lines you want displayed when the down arrow is clicked. In our example, the combo box is linked to cell B1 and the cell range for the list is A1:A2. Tip: You can use the INDEX function to show an item name instead of a number.

Excel add ins list