Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing from Excel for XLSX
Message
De
20/01/2015 03:33:18
 
 
À
19/01/2015 17:16:46
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:
01613949
Vues:
27
>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?

I think this came up in another thread recently. The database engine is still used 'under the hood' for a lot a MS stuff - so, yes, you need it :-{
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform