How can I insert multiple lines once only using Sql?

Question

I exported a Sqlite data record to Sql Server with Dump. I need to take these records and insert them into a new table that I created to receive these records within my database in Sql server. The problem is that I have many lines to insert.There are over 1,000 lines and I wonder if there is a simpler way to do this than to repeat 1000 times the Insert into nameDaTable values...

ex:

INSERT INTO MyTable VALUES ("John", 123, "Lloyds Office");
INSERT INTO MyTable VALUES ("Jane", 124, "Lloyds Office");
INSERT INTO MyTable VALUES ("Billy", 125, "London Office");
INSERT INTO MyTable VALUES ("Miranda", 126, "Bristol Office");
INSERT INTO MyTable VALUES ("John", 123, "Lloyds Office");
INSERT INTO MyTable VALUES ("roger", 23, "Nuvens");
INSERT INTO MyTable VALUES ("jose", 500, "London Office");
INSERT INTO MyTable VALUES ("elanda", 126, "Paris");

Let’s imagine that these Insert have more than 1,000 Is there a way to make it easier without repeating 1,000 times?

here is a print of how the records are:

Answer 1

There are some simpler ways to copy this data:

Linked Server You can make a Linked server from the source server on the target server. This way you can make an Insert based on a select.

Data import You can import the data by Wizard sql server, right-clicking on the target database, go to tasks and import data, as in the following figure

Manually edit the records in the table There is still the possibility to right-click on the target table in the explorer Object and click on the item "Edit 200 rows higher". With this option the table will open as in excel. And it will be possible to paste the records if they are in the clipboard (either as source in a grid, select result or excel).

Answer 2

Go to your sqlite and make a query that manages the querys:

select 'insert into ..... values ('+Campo+','..... from sua tabela....

The result must have the'load script'

Another option is to export the database structure using the Sqlite Browser, using the option Export to SQL.

EDIT

You can use the result of a select to include records in a table:

insert into tabela values select campos from tabela.....

Answer 3

So guys with your help I managed to solve this mystery. to replace in the right place, I had to use a regular expression by the site https://regex101.com/ test if he could find exactly where I should be doing my replace. My regular expression in my case was VALUES. *, ([0-9]{5}), 5 digits.'

After he found I just replaced it with values I wanted in a row and I used the Notepad++ macro as recommended by someone here to repeat the same action for all rows and then play sql and run the records and insert in the database.