The elements must be specified: DRIVER= as well as the element DBQ=”D:\Dossier\File_Excel.xlsx” which is the location of the file for example.įinally, the operating systems supported by the Microsoft Office Database Access 2010 drivers and components are the following: For ODBC connections, it is possible to connect to Excels files: XLS, XLSX, XLSM, XLSB.To connect to Microsoft Office Excel type databases, add “Excel 14.0” to the connection string properties (also ConnectionString).If you are using applications that use OLEDB, you must specify the argument “.12.0” in the ConnectionString property.Follow the on-screen instructions until the installation is complete.įinally, make use of the drivers by creating Excel connections using the drivers. Double-click the AccessDatabaseEngine.exe file to install it on the target server.
0 Comments
Leave a Reply. |