- introduction
- picture
- Boutique
- Related
Developer's DescriptionBy CDataConnect Excel with SQLite data.The SQLite Excel Add-In is a powerful tool that allows you to connect with live data from SQLite databases, directly from Microsoft Excel. Use Excel to read, write, and update SQLite Tables. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live SQLite tables of data. *Key Features:-Completely self-contained; no additional software installation is required.-The Excel Add-In for SQLite is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.-Modify and delete Records.-Quickly export and backup data.-Operate on data with Charts and Pivot Tables.*Easy-To-Use, Straightforward Configuration:1I-nstall the Add-In2-Login with User & Password3-Select TablesInstalling any of the Excel Add-Ins creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.Once the data connection is configured, just specify the table and the Excel Add-In will populate a new Excel sheet with live SQLite Data.