I wrote this sample console program to read Excel file and bulk load to the SQL.
It uses the ExcelDataReader NuGet package. The source is located on GitHub. Enjoy!
https://github.com/pankajsurti/BulkLoadExcelData2SQL
-
Recent Posts
- How to retrieve Response header values from the Custom Connector in PowerApps Canvas App? May 25, 2023
- Microsoft Build 2023 (May 23-25) May 25, 2023
- How to create a JSON String array in PowerApps? May 24, 2023
- How to resolve “FHIRBase.GETPatient failed: Failed to execute ‘atob’ on ‘Window’: The string to be decoded is not correctly encoded.” error? May 20, 2023
- How to clean up the FHIR objects in the Postman received as a bundle? May 17, 2023
Recent Comments
Julie Bird on How to hide welcome message fo… Erik on How to Export Intune reports u… Jonnie on How to add a Checkbox to a Pow… Jeff Flogerzi on How to send approval requests… Chris on How to fix an infinite trigger… Archives
- May 2023
- February 2023
- January 2023
- December 2022
- October 2022
- September 2022
- August 2022
- July 2022
- June 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- September 2021
- August 2021
- July 2021
- June 2021
- April 2021
- February 2021
- December 2020
- November 2020
- October 2020
- September 2020
- August 2020
- July 2020
- June 2020
- May 2020
- April 2020
- March 2020
- February 2020
- October 2018
- April 2015
- February 2015
- January 2015
- December 2014
- November 2014
- June 2014
- March 2014
- January 2013
- October 2012
- September 2012
- August 2012
- July 2012
- May 2012
- April 2012
- February 2011
- December 2010
Categories
Meta
Pankaj Surti's Blog 