Skip to main content

Importing .csv files to SQL server

In this I post I will try to demonstrate how we import a .csv file which we downloaded from online to SQL Server.We use the table which we import to do some other SQL practices in the next topics.
We start by creating a database called 'Nobel_Laureates'. Open SQL Server Management Studio and create a new query window by clicking on 'New Query' menu or by hitting 'Ctrl + N' on your keyboard.
Lets create a database called 'Nobel_Laureates' using the following code.

CREATE DATABASE Nobel_Laureates
USE Nobel_Laureates

Now lets download the list of all the Nobel Laureates from online using this link, or by copying and pasting 'https://www.aggdata.com/download_sample.php?file=nobel.csv' on your browser.
The link downloads a .csv file with a name 'nobel.csv' on your default downloads folder.
Once the nobel.csv file is downloaded, We import it to our Database as follows. Right click on the 'Nobel_Laureates' database.



 And go to 'task' and then click on  'import data'.The 'SQL Server Import and Export Wizard' dialogue box pops up.
Read the content and Click Next.


From the Data Source list Select Flat File Sources,click Browse button to select the nobel.csv file from your downloads folder. Leave everything else as it is and click Next.


Leave everything as it is and click Next.

 Leave everything as it is and click Next.

Leave everything as it is and click Finish.



Now You have the 'nobel' table in your database.





This Week's Best Picks from Amazon

Please see more curated items that we picked from Amazon here .

Popular posts from this blog

Exploring Sentiment Analysis Using Support Vector Machines

Sentiment analysis, a powerful application of Natural Language Processing (NLP), involves extracting opinions, attitudes, and emotions from textual data. It enables businesses to make data-driven decisions by analyzing customer feedback, social media posts, and other text-based interactions. Modern sentiment analysis has evolved from simple rule-based methods to advanced machine learning and deep learning approaches that detect subtle nuances in language. As text communication continues to dominate digital interactions, sentiment analysis is an essential tool for understanding public opinion and driving actionable insights. The GoEmotions Dataset The GoEmotions dataset, developed by Google Research, is a benchmark in emotion recognition. It consists of over 67,000 text entries labeled across 27 emotion categories, such as joy, anger, admiration, and sadness. For practical applications, these emotions can be grouped into broader categories like positive and negati...
Read more

Autonomous Vehicles and AI Integration

Autonomous vehicles (AVs) represent one of the most transformative innovations of modern technology. These vehicles leverage artificial intelligence (AI) technologies to perform tasks traditionally carried out by human drivers, such as navigation, obstacle avoidance, and traffic management. The integration of AI into autonomous vehicle designs has enabled advancements in safety, efficiency, and convenience. This paper examines the current state of technologies involved in AV development, emphasizing the role of AI in supporting various vehicle functions and passenger needs. Additionally, it provides an overview of key organizations driving advancements in this field. AI Technologies Underpinning Autonomous Vehicle Development Artificial intelligence is central to the operation of autonomous vehicles, providing the computational foundation for critical capabilities such as perception, decision-making, and control. These capabilities are achieved through the integration of multiple t...
Read more

Intelligent Agents and Their Application to Businesses

Intelligent agents, as a key technology in artificial intelligence (AI), have become central to a wide range of applications in both scientific research and business operations. These autonomous entities, designed to perceive their environment and adapt their behavior to achieve specific goals, are reshaping industries and driving innovation. This post provides a detailed analysis of the current state of intelligent agents, including definitions, theoretical and practical perspectives, technical characteristics, examples of business applications, and future prospects. Definitions and Terminology Intelligent agents are broadly defined as autonomous systems that can perceive and interact with their environments using sensors and actuators. Their autonomy enables them to make decisions and execute actions without constant human intervention. They operate with a specific goal or objective, which guides their decision-making processes. These entities may exi...
Read more