- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 05:49:51
- Related Questions & Answers
- Importing data from Pgsql to SAP HANA database
- How to display MySQL Table Name with columns?
- Getting table name in SAP system
- Table type while importing data from flat file in SAP HANA
- Maximum Table name length in SAP HANA
- Different table symbol in SAP HANA database
- Default table type in SAP HANA database
- Creating column table in SAP HANA database
- Password blacklist table in SAP HANA database
- Merging 2 tables with similar column name SAP HANA database
- Filter output columns in Table in SAP application
- In SAP ABAP, mapping two database table fields
- Viewing data in a table in SAP HANA database
- Changing storage type of table in SAP HANA database
- Aggregating rows in SAP ABAP with the same name
Advertisements