Some reports that Excel 2003 need the exta OLEDB section in the beginning of the string.Hello guys , i use this in my databaseconnect ativity to connect to an excel ProviderMicrosoft.ACE.OLEDB.12.0.1 answer Top answer: Hello thanks guys its okay now i used in my uipath.database.connectProviderMicrosoft.Jet.OLEDB.4.0 Data Source+inFolderPath+. Standard alternative Try this one if the one above is not working. Standard (Excel) ProviderMicrosoft.Jet.OLEDB.4.0 Data SourceC:\MyExcel.xls Extended Properties'Excel 8.0 HDRYes IMEX1' How to Use JET in 64 bit environments.
...
Both engines provide similar functionality, but ACE follows the design principles of Office and isn't suited for some of the previous scenarios that are supported by Jet. The architecture of ACE must match the architecture of the Office installation on that computer. However, only one architecture is allowed on a device. ACE is provided in both 32-bit and 64-bit architectures. The Access Database Engine, also called Access Connectivity Engine (ACE), is the Office database engine that's built from the foundation of Jet. More informationThe Jet Database Engine was designed to be a general-purpose database engine that's supplied together with Windows.
0 kommentar(er)
