Asked By
alitatmaja
0 points
N/A
Posted on - 08/29/2011
Dear all,
I’ve copied some files (Word and Excel files) from my office mate. The Word file contains some merge field so when I open the Word file, it will need a data source which is the Excel file. But I could not load the Excel file.
It gave me some errors, when I tried to load the Excel file.I tried it twice but did not succeed. It gave me this error message: “Specified driver could not be loaded due to system error 126 (Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb))”
-
I provided some snapshots. I would like to attach the files but the system not allowed file with the following extensions to be uploaded (*.docx, *.xlsx).
-
Does anybody have experienced this thing? It would be nice if anybody would like to share it or solve this. Thanks for your time.
Microsoft Office Word
Opening this document will run the following SQL command:
SELECT *FROM ' Sheet1$'
Data from your database will be placed in the document. Do you want to continue?
Microsoft Office Word
Error has occurred: The specified module could not be found.
Open Database Connectivity Error
Specified driver could not be loaded due to system error 126 (Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *xlsb)).
Specified driver could not be loaded due to system error 126
Though you have the Excel files needed for your Word file to wok perfectly, but you do not have the resources of your computer needed to do the merging. That files are needed and you can only make it working by installing these DLL files to your computer.
Your office mate may have that files installed from an SQL Server Installation package. All you need is the client tools and it is essential in dealing with Database stuff. Just secure the installer and all the installation is just as simple as “Next and Next” instructions.
Just follow through the installer’s “on screen guidelines”.
Answered By
raymondc
0 points
N/A
#119560
Specified driver could not be loaded due to system error 126
-
You need to install DLL files to work on further
-
You can copy those DLL files from your office mate's computer. It's a one method.
Just simply click next > next > next to overcome it that's the easier way. You just type *.dll in the search box and confirm to look for a hidden file also from it you can find the .dll file you want or just type the exact name of the dll file and open location copy it and paste it in your computer in the same path ( I assume that both of you guys have the same O/S ) then you will able to work
or
You can use a client tool and install it. Just simply click next > next > next all the information will display on GUI setup mode. I Think that's the easiest way to do that. ( hope that you will able find the client package )
Answered By
kerubo
0 points
N/A
#119563
Specified driver could not be loaded due to system error 126
The information or data that come from an external data source may be hard to copy and run in a different program. This data source is connected through a data connection which describes how to locate, log in and access the external data source.
When you copy the data repeatedly it might be time-consuming and with errors. So what you need to do is use and connect an Office Data Connection (ODC) file (.odc) or in a Data Source Name (DSN) file (.dsn).
Therefore, to copy the data into your program, access to the data in your local computer. If the data source is a text file or a workbook, it may not have the permission to access it.
