question

ncode.bayat avatar image
ncode.bayat asked

How to Format File to Map Table Columns Bulk Insert

Hi, I have a text file that looks like this

Running  FaraGostar Lice... idea license server service        server0
Running  Fgconvertservice   idea Convert Service               server1
Running  FgOprService       idea Operation Service             server2
Running  FgWordToImageSe... idea WordToImg Service             server3
Running  Fgconvertservice   idea Convert Service               server4 
Running  FgOprService       idea Operation Service             server5 
Running  FgWordToImageSe... idea WordToImg Service             server6 

------------------------------------------------------------------------------------------------------------------------------------------

A table like this is hard for me

CREATE TABLE MyTemp  (MyTime                time,
MyEXCEPTION      CHAR (1000),
MyActio               CHAR (1000) , 
MyJSON               CHAR (1000)
)

Now, my problem is to format this text file and enter it. Thank you for the formatting of this file and how to enter it.

Finally, the information will be entered into my table in this way

insertcolumnsfilebulkformat
table.png (60.0 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.