---
title: "How to import csv file data in SQL server table?"  
description: "How to import csv file data in SQL server table?"  
author: "Anonymous User"  
published: 2012-03-24  
updated: 2012-03-26  
canonical: https://www.mindstick.com/forum/397/how-to-import-csv-file-data-in-sql-server-table  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to import csv file data in SQL server table?

Hello Guys,\
I'm facing a [problem](https://yourviews.mindstick.com/view/81399/tackling-the-problem-of-unemployment-during-corona-pandemic) since last night, please help me! Actually I want to [import csv](https://www.mindstick.com/forum/393/how-to-import-csv-file-in-php) file [data in sql](https://www.mindstick.com/articles/12937/how-to-import-excel-data-in-sql-server-2014) [server database](https://www.mindstick.com/forum/156824/what-is-normalization-in-sql-server-database) but I didn't. Could you [explain](https://www.mindstick.com/forum/157854/what-is-system-debugging-explain-some-system-debugging-tools-used-in-modern-computer-systems) it with code?\
\
Please reply as soon as possible. Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!!

## Replies

### Reply by Anonymous User

Hi Tanuj Kumar,\
To import data from csv file in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server), you have to use BULK Query Command. Let's take look of Bulk Query Command query.\
\
**Query:**

```
BULK INSERT tbl_Name               FROM 'csvFileNamewith Path'                  WITH                      (                        FIELDTERMINATOR = ','                     )
```

I hope it might be resolve your problem.


---

Original Source: https://www.mindstick.com/forum/397/how-to-import-csv-file-data-in-sql-server-table

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.