Press "Enter" to skip to content

Data Migration between SQL Server and Excel with Powershell

Mikey Bronowski shows how to shuffle data around:

ImportExcel is a powerful tool to manage MS Excel, however, the user is not limited to data stored in worksheets. We can import from and export to SQL Excel data using a combination of ImportExcel and dbatools modules.

You can read how to start with dbatools in this blog series.

Click through for a demo.