BCP - Bulk Inserting / Copying to Sql

[whyt3boi]

So I've asked for help a few days ago on this subject of inserting textdata from the media. And replies were related to Bulk Inserts using BCP.

I do realize that some people are conservative on how much they want to tell the community due to competition.

So all bullshit aside. So we don't make any mistakes to the database or other files I need someone to share their method of using Bulk Inserting through BCP or other Sql Import tools.

Use an example of a textdata file and where it needs to be imported.

I do understand some have said _ObjCommon is used for Media/server_dep/silkroad/textdata

[jangan322]

idk what you are asking for exactly but this might help you.
Credits to Artuuro.

use SRO_VT_SHARD // change the db name
BULK
INSERT _RefSkill // change your table name
FROM 'C:\Users\Artuuro\Desktop\enc\Skilldata_35000enc.t xt' // Edit this to your location
WITH
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)

[Unrealx420]

Originally Posted by jangan322

idk what you are asking for exactly but this might help you.
Credits to Artuuro.

use SRO_VT_SHARD // change the db name
BULK
INSERT _RefSkill // change your table name
FROM 'C:\Users\Artuuro\Desktop\enc\Skilldata_35000enc.t xt' // Edit this to your location
WITH
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)

would be nice if this actually worked..