The link from provider to datasource in this case is through OLEDB, using the Access engine to query Excel files.You could use a different library to read the Excel file, but then youll have to find a library that offers querying - or reimplement that part yourself, using said library.Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.Making statements based on opinion; back them up with references or personal experience.
Not the answer youre looking for Browse other questions tagged c asp.net-mvc linq or ask your own question. This redistributable provides a 32-bit or a 64-bit version of the Microsoft ACE OLEDB Provider which can be downloaded here. To have it run properly you need to launch it from a command line with the passive argument specified. By clicking allow or continuing to use this site, you agree to the use of cookies. Microsoft Access Database Engine 2010 Redistributable Drivers Have BeenIf you have Microsoft Office already installed, you should be fine, because the drivers have been installed with the product. Microsoft offers the runtimeredistributable packages for download. Microsoft Access Database Engine 2010 Redistributable for download. The same redistributable packages are available on NiceLabel DVD. Microsoft Access Database Engine 2010 Redistributable Software Will AddInstalling this software will add the necessary ODBC and OLE DB drivers. The redistributable package exists in two flavors, as 32-bit and 64-bit installation. The version you would install depends on the application that will connect to the Office data files. For example, NiceLabel Automation service will run as 64-bit application. Automation Builder (the application to configure your trigger) always runs as 32-bit application, while Automation service auto-determines the Windows system version and runs as 32-bit or 64-bit. When you test your triggers in Automation Builder, they might not function the same in Automation service, because service will use 64-bit database drivers. All other NiceLabel applications will still run in 32-bit mode. Designers always run as 32-bit applications, while Automation service runs as 64-bit process in 64-bit Windows. It doesnt matter which version of Microsoft Office you have, it can be 32-bit or 64-bit. The key point is that you install Microsoft Access Database Engine 2010 Redistributable of the opposite bitness. If you have 32-bit Microsoft Office, then install Microsoft Access Database Engine 2010 Redistributable 64-bit and vice-versa. Can I couple it with Microsoft Access Database Engine 2010 Redistributable. For example, database drivers for Office 2007 install as version 10.0, for Office 2010 they install as version 12.0, for Office 2013 they install as version 15.0. If you install Database Engine 2010 64-bit, the Automation service will seek provider version 15.0, but only 12.0 will be available as 64-bit provider.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |