Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
Updated on: 28-Jan-2020
99 Views
Advertisements