Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing from Excel for XLSX
Message
De
19/01/2015 17:16:46
 
 
À
19/01/2015 16:50:28
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01613933
Message ID:
01613935
Vues:
28
I did adapt my class to support this:
        ' Based on the type
        Select Case loFileType.nNoFileType

            ' XLS
            Case 3

                ' Initialization
                lcConnection = "provider=Microsoft.Jet.OLEDB.4.0; data source='" + cSource + "'; Extended Properties=Excel 8.0;"

                ' XLSX
            Case 18

                ' Initialization
                lcConnection = "provider=Microsoft.ACE.OLEDB.12.0; data source='" + cSource + "'; Extended Properties=Excel 8.0;"

        End Select
However, at first, it says this:

"Microsoft.ACE.OLEDB.12.0' provider is not registered on the..."

So, this was required to make it work:

"2007 Office System Driver: Data Connectivity Components"

Once prompted to download, I ended with this file: AccessDatabaseEngine.exe

This works. But, I have some doubt as to know what was installed exactly.

So, when looking at the program files, I see: "Microsoft Office Access database engine 2007 (English)"

Talk about going around something you do not want. Is there really such a driver or we have to install this Access software?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform