DEV Community

Cover image for Import file in SQL Server
Clever Cottonmouth
Clever Cottonmouth

Posted on

Import file in SQL Server

Importing a CSV File into SQL Server Database Table

Importing a CSV file into an SQL Server database table is very straightforward using SQL Server Management Studio (SSMS). Here's a step-by-step guide:

Step 1: Prepare the CSV File

Ensure your CSV file (e.g., Data.CSV) is ready for import.

CSV File Example

This file is located in a local folder, e.g., Inputfile.

File Location

Step 2: Open Import Flat File Wizard

  1. In SSMS, right-click on the database where you want to import the file.
  2. Navigate to Tasks > Import Flat File.

Import Flat File Option

Step 3: Introduction Window

An introduction window will appear. Click Next.

Introduction Window

Step 4: Specify Input File

  1. Select the CSV file you want to load.
  2. Specify the table name (e.g., InputDatFile) and schema (e.g., dbo).
  3. Click Next.

Specify Input File

Step 5: Preview Data

The Preview Data window displays a preview of your file's contents. Validate the data, then click Next.

Preview Data

Step 6: Modify Columns

In the Modify Columns window, adjust data types, set primary keys, or make other changes as needed. When finished, click Next.

Modify Columns

Step 7: Review Summary

Review the summary of your inputs, including the file name, database name, and table name, to ensure accuracy.


This completes the process of importing a CSV file into an SQL Server database table.

Billboard image

The fastest way to detect downtimes

Join Vercel, CrowdStrike, and thousands of other teams that trust Checkly to streamline monitoring.

Get started now

Top comments (0)

Heroku

Simplify your DevOps and maximize your time.

Since 2007, Heroku has been the go-to platform for developers as it monitors uptime, performance, and infrastructure concerns, allowing you to focus on writing code.

Learn More

πŸ‘‹ Kindness is contagious

Dive into an ocean of knowledge with this thought-provoking post, revered deeply within the supportive DEV Community. Developers of all levels are welcome to join and enhance our collective intelligence.

Saying a simple "thank you" can brighten someone's day. Share your gratitude in the comments below!

On DEV, sharing ideas eases our path and fortifies our community connections. Found this helpful? Sending a quick thanks to the author can be profoundly valued.

Okay