Import csv into SQL Server Using the Import Export Wizard
Here’s my second SQL server tutorial of the week, this time demonstrating how to import csv files into SQL tables, I may have to change the name of the blog at this rate.
sql-server
A collection of 4 posts
SQL and the 80/20 Rule
I’ve just spent 2 hours with our DBA trying to force SQL to apply the 80/20 rule to a massive data source. I’m so pleased with the result that I have to write it up as a tutorial even though...
Converting T-SQL for MS Access SQL Queries
I’m moving to pastures new and will be leaving behind a well-loved SQL Server database, complete with a rich array of patient level data. At my new job I will likely have to make do with an Access database and...
Importing CSV files to an SQL Server Database
I regularly need to set up new tables in my SQL Server Database from data held externally as either text or csv. It sounds like an incredibly straightforward task but always sends me scurrying off to google for advice on...