---
title: "How to import and export data in SQL server from different file format"  
description: "How to import and export data in SQL server from different file format"  
author: "Anonymous User"  
published: 2012-02-13  
updated: 2012-02-13  
canonical: https://www.mindstick.com/forum/382/how-to-import-and-export-data-in-sql-server-from-different-file-format  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to import and export data in SQL server from different file format

Hello Everyone, \
Is there any [option](https://www.mindstick.com/forum/159391/jquery-get-selected-option-from-dropdown) in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) to [import](https://www.mindstick.com/blog/294/how-to-import-or-export-sql-server-table-data-in-ms-excel-sheet-using-c-sharp-code) [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) from [text file](https://www.mindstick.com/forum/12828/converting-a-text-file-to-an-array-in-java). \
Please [resolve](https://www.mindstick.com/forum/159427/windows-app-dll-not-found-resolve-library-issue) my [problem](https://yourviews.mindstick.com/view/81399/tackling-the-problem-of-unemployment-during-corona-pandemic) as soon as possible. \
\
Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!

## Replies

### Reply by Pravesh Singh

Hi Arun Singh,\
Yes! SQL [server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over) has an option to resolve this problem. To import data from [text](https://www.mindstick.com/blog/301635/did-people-reinvent-texting-to-express-the-full-range-of-emotions) file in SQL table, you can use Bulk Query command. Let's take a look of this command.\

```
BULK INSERT table_Name FROM 'c:\fileName.txt' WITH (FIELDTERMINATOR = ',')
```

I hope it might be useful for you.


---

Original Source: https://www.mindstick.com/forum/382/how-to-import-and-export-data-in-sql-server-from-different-file-format

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