When we think of importing and exporting data into SQL Server, whether it be from Excel spreadsheets or some other source, we do have to be careful. If we want to import data into a Production system – this is probably a bad idea period. If proper monitoring is happening on the server, someone will…… Continue reading Wrapping Everything Up Importing and Exporting
Month: June 2021
More Fun Exporting Data with R
Up until now, we have reviewed getting data out of SQL Server and into Excel. We’ve done it via several means: How to Export data to Excel Have Fun Gathering Data to Excel Using More Tools Even More Fun Exporting Data With PowerShell In today’s post, we’ll go over how to export the data you…… Continue reading More Fun Exporting Data with R
Even More Fun Exporting Data With PowerShell
Earlier, we discussed using PowerShell to import data from a spreadsheet into SQL Server using a method described here. Now, we want to do the exact reverse – export the data from SQL Server to a spreadsheet using PowerShell. As you’ll notice in the linked post, it uses the ImportExcel module. Well, we’re going to…… Continue reading Even More Fun Exporting Data With PowerShell
Have Fun Gathering Data to Excel Using More Tools
In our last blog post – seen here – I showed one way of getting data into an Excel spreadsheet. If you attempted it, you saw how many clicks there. There’s lots of clicking with the wizard. https://www.youtube.com/watch?v=bWq4HR69enc Clickety-clickety Now, let’s try doing it a different way. First, let’s open up the one tool that…… Continue reading Have Fun Gathering Data to Excel Using More Tools
How to Export data to Excel
For the last few posts, I’ve been going on about various ways in which you can import data from spreadsheets into SQL Server. But, why should it only work one way? Why can’t we export data as well? Good question, my friend! One of the ways that you can export data is by using our…… Continue reading How to Export data to Excel