First, you'll need to choose ODBC as the source to load data from. To do so, click on the Data tab, then New Query button, in the drop-down menu expand From Other Sources, then choose From ODBC:. ODBC as data source. This will open a new window with a drop down menu populated with the DSNs that Excel found on the system. My current method for working with this input spreadsheet is to: Create a new Passolo project and add the 15 target languages. Split the spreadsheet into separate spreadsheets, by sheet name Import into my Passolo project. Configure the column to translate etc using the Excel Add-on. Delete the unrequired strings lists for each language. Set up the Excel spreadsheet as an ODBC data source On your Windows machine, go to Settings->Control Panel->Administrative Tools->Data Sources (ODBC). Click Add Select Microsoft Excel Driver (*.xls). Hit Finish. Give a data source name of amnu and give any description you desire (or leave it blank). Devart ODBC drivers enable you to connect to data stored in RDBMS and cloud-based applications, such as MySQL, SQL Server, SQLite, BigCommerce or Mailchimp, on Windows, macOS, and Linux (cloud-based applications are currently supported only on Windows). With our 32-bit and 64-bit ODBC drivers, you can pull entire tables or execute SQL Figure 11-35: Employees.xls data view. Again you can access the Excel database either using an ODBC DSN or bypassing the database name directly in the connection string. In this sample, you're passing the database name directly: string ConnnectionString = @"Driver= {Microsoft Excel Driver (*.xls)};DBQ=c:Employees.xls"; Create Visualizations of Excel Tables Follow the steps below to connect to the DSN and create real-time data visualizations: Click File -> Add Data Tables. Click Add -> Database. In the Data Source Type menu, select ODBC Provider and click Configure. Select the DSN. Select the tables that you want to add to the dashboard. This example uses Sheet. This classic business report or business scorecard shows executives all their critical for success metrics and KPIs with charts and trends over time and summarizes all important data for making smart business decisions. In addition, the product includes Balanced Scorecard Templates and Pareto Tool. "No Excel skills needed. Select Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC). This opens the ODBC Data Source Administrator dialog box. Navigate to the System DSN tab and click Add to open the Create New Data Source dialog box. Select Microsoft Excel Driver as the driver for which you want to set up the data source. Note: OpenLink also offers a Lite Edition (Single-Tier) JDBC-to-ODBC Bridge Driver, which may be used if ODI is installed on the same Windows host as the Excel ODBC Driver (and spreadsheet). You don't need one; I do this for you at fraction of the cost. I can help you create and maintain a highly specialized, advanced Excel model to forecast your business or create an operation plan. A tab that includes all the assumptions for growth and trends: pricing, market share penetration, product mix change, cost reduction, etc. Multiple Go ahead and it open up, spreadsheets when prompted for clients who visit this if we want. Select bend table opposite the aspire side what the Navigator window group click Load table Table Result Your database records in person Access Data between Excel 6 When your.