How to Import a CSV File in an SQL Query

Are you wondering how to import a CSV file in an SQL query? Here we take you through the steps using SQL and openrowset. This will allow you to read the create a table, read the CSV file and load the file contents into the table you just created. Theoretically, you could do this for lots of files, as a result, you could automate certain tasks, as long as the file exists.

⏲⏲⏲TIMESTAMPS⏲⏲⏲
Beginning 00:00
Introduction 00:01
Import through menu option 01:35
Import through SQL query 02:44
Openrowset explanation 03:28
Insert using openrowset 05:55

################ Let's be Social! ##################

#sql #CSV #dataanalyticsireland #fileimport #csvimport #automation

[vutrhuyify]

What is the numbers 9.0 and 3 in csv_file_import_set.txt mean?

[pablohergenreder]

hello! Thank you very much for the video. I am trying to do it with my csv and when executing it tells me that the txt is incomplete or cannot be read. any idea why that would be? i want to import only 2 out of 3 columns from the csv, the datatype is varchar(255) and decimal

[namratanagvekar]

Why my csv file is not fully loaded on importing it on workbench? And what to do for complete file. Plz reply me.