SQL Server mass insert

See more:

SQL-Server

MS-Excel

Hi,

I am trying to do a script to insert a list of country and their corresponding account numbers to a table in SQL.
However the system admin does not allow me to link or import the file into a table directly hence I have to set up a procedure to manually import those data.

I am trying to do a

INSERT INTO Finance_APAC.dbo.testBreakAsean (Country, Account) VALUES ('Test1','Test2')
INSERT INTO Finance_APAC.dbo.testBreakAsean (Country, Account) VALUES ('Test3','Test4')
INSERT INTO Finance_APAC.dbo.testBreakAsean (Country, Account) VALUES ('Test5','Test6')

and use a formula to trap those country/account numbers from an excel sheet and do a paste of the insert command into my SQL server, however excel would report errors when I use a "','" which is neccessary for me to insert the Country or account

Is there anyway to sidestep this problem? This might be more of an excel question then SQL. Thanks for any expertise on this.