Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SSIS package to import from Excel
Message
 
 
À
14/07/2022 11:06:03
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01684637
Message ID:
01684657
Vues:
34
>First I downloaded the SDK - I forget where I got it - and then I used the Nuget Package Manager to add it to the project.
>
>Then I added these lines to the Usings:
>
>
>using DocumentFormat.OpenXml.Packaging;
>using DocumentFormat.OpenXml.Spreadsheet;
>
>
>As I said I haven't done much with it. I just got it to read the spreadsheet and display some of the columns.
>What I saw looked promising.

I found the nuget package already and installed it, so I'm trying to write a simple console app now. I also found code which looked like it may work (not sure yet, but going to try)
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform