Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SSIS package to import from Excel
Message
 
 
To
14/07/2022 11:06:03
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01684637
Message ID:
01684657
Views:
33
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform