By using the Excel ODBC driver (available as well as many others for Access, SQL Server, Oracle, MySQL, etc.), we create a Windows ODBC connection for the Excel file, in which we have assigned a “Name” to the table range containing the data of the points. Kyle123 said: Thats caused by an error in your connection string, are you sure its correct. The possible reasons for encountering issue about version mismatch: 1- If you attempt to do the following on a 64-bit Windows machine: - Connect a 64-bit. The ODBC provider allows access to any database or file routed through the Windows Open Database Connectivity ODBC.For the use of this provider, the range of the table containing the data of the points to be imported will be saved as a Comma-separated values (CSV) file from Excel

Make sure that you choose the ODBC Data Source Administrator that has the same bitness as. In the opened dialog, select ODBC DSN and click Next to continue. In the Start menu, type ODBC Data Sources. Click From Other Sources, and then click From Data Connection Wizard. In the opened dialog, select ODBC DSN and click. Connecting Excel to SQL Server with Data Connection Wizard (Legacy Wizard) You can use this option to connect to OLE DB or ODBC external data source that has already been defined. This provider allows you to read and write many text ASCII files (CSV, TXT, ASC, etc.) in a preset or user-defined format and to specify any parameter relating to the format itself or to the import process. Connecting Excel to SQL Server with Data Connection Wizard (Legacy Wizard) In Excel, go to the Data tab.Two different import methods have been used while recording the videos:

Excel odbc manager