So, after importing data to SQL Server from Excel now it is time for the reversing policy. Actually, much of the code was available in the Microsoft site here, but still, it was not all that I needed. I wanted to make …

MSSQL – Export data from SQL Server to Excel with VBA Read more »

Let’s imagine the following situation. You work in a small company, where one excel spreadsheet is used by many users locally. But you still want to see some kind of track of the results in a collected option. E.g. some information, …

MSSQL – Import data from Excel to SQL Server with VBA Read more »