To use EXCEL VBA data read recently, error in statement for connecting to the database, but you can run in a computer, what is the problem, the OLEDB driver is installed, tools of references are cited
Code:

Error:

CodePudding user response:

The error of machines, haven't run MSADO object code to use?

You try to use "run as administrator" to start the Excel, and see if I can use,