I recommend that you use the BCP utility to import/export data to a text file in SQL Server. When you run the following command, it loads the data into a text file.
BCP Db.TN out "Location of the text file " -c -S ServerName –T
Now, if you want to load data from a flat file into SQL Server, you can use the following command:
BCP Db.TN in "Location of the text file " -c -S ServerName –T
You can also try to edit the mapping while loading the data from the flat file.
The above is the detailed content of In SAP database, import table columns with / in the name. For more information, please follow other related articles on the PHP Chinese website!