HealthAnalyticsToolkit

Importing Data into SQL

As a data analyst, you may have data in file formats like xlsx, csv, or txt. You are able to import these files into SQL for your use!

CSV

IMPORT CSV 'file_path' INTO table_name;

This will import all the columns from a csv file into a table. Then you can move forward with your analysis!

Not sure how to move forward? Try taking a look at these basics or this example!

TXT

IMPORT TXT 'file_path' INTO table_name;

Same as with the csv, this will create a table with all the data from the file.