Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • About
  • Toggle search form

Category: Excel

The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

I was trying to load the content of an xlsx file into a Sql Server database using the “Sql Server import and export wizard” provided by Sql Server Management Studio, and I got the following error “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine”. The error persisted even after the installation of the…

Read More “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine” »

Excel

Zipping xlsx file correctly

As most of you know, an xlsx file is actually a zip archive containing some xml files. If you change the extension of the file from “xlsx” to “zip”, you can extract the content using a software like 7-Zip. Once extracted the content of the file, you can make some modification and zip to get…

Read More “Zipping xlsx file correctly” »

Excel

Copyright © 2023 The Dummy Programmer | Privacy Policy | Terms of use |

Powered by PressBook Masonry Dark