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.

Johar Ali

Published on 20-Dec-2017 07:26:35

• 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
• Using single quotes around database and table name isn’t working in MySQL?
• Table type while importing data from flat file in SAP HANA
• Merging 2 tables with similar column name SAP HANA database
• 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
• Find the largest rectangle of 1’s with swapping of columns allowed in Python
• Filter output columns in Table in SAP application
• CODD’s Twelve Rules of Relational Database
• In SAP ABAP, mapping two database table fields