StrFile = ThisWorkbook.Path & "\" & ThisWorkbook. Thoughts on reconfiguring this for the new Excel? Function ReportGroup(strSQ元3 As String) As Recordset However, when I am in Excel and begin a new database. need ODBC (64 bit) Driver for excel (version 12 and after) on windows server 2019, where no MS office is installed.
The code that is failing is below, it specifically highlights the ".Open" in the "With cn" section. I believe I have created the DSN correctly thru ODBC Manager as I can run the test successfully. Data source name not found and no default driver specified.
#Excel odbc manager install
If you are connecting to other ODBC data sources (for example, FileMaker Pro), then you will need to install the ODBC driver for the data source on your Mac. If you want to connect to SQL DB, on the Data tab, click New Database Query > SQL Server ODBC. I inherited an Excel macro that works fine in Excel 2013 (file is saved in XLS format and appears to use a 32-bit ODBC Microsoft Excel driver) and I get the following error when trying to run the same macro in Excel 2016 which appears to use a 64-bit Excel driver. The new versions of Excel do provide an ODBC driver for connecting to SQL Server Databases.
0 kommentar(er)
