Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Selected Reading
In SAP database, Importing table columns with /’s in the name
I would suggest you to use BCP utility to perform an import/export of data to a text file in SQL Server. When you run below command, it loads data to a text file.
BCP Db.TN out "Location of the text file " -c -S ServerName –T
Now if you want to load data to SQL Server from a flat file, you can use this:
BCP Db.TN in "Location of the text file " -c -S ServerName –T
You can also try editing Mappings while loading data from a flat file.

Advertisements
