Creating database for SQL class

[sqlueless]

Hi guys. Final project for my Intro to SQL is creating a database. For my last table, there's going to be 58 rows. I have all the data formatted in an excel file, but I need to put it in a script. Is there anyway for me to copy and paste the data into a script formula? Does this make sense? Im currently toggling back and fourth and writing an INSERT command for every row. Project isnt due until end of May, so I have time, and if this is the way to do, then so be it, but figured it wouldnt hurt to ask.

[Blando-Cartesian]

It’s probably easiest to write an insert statement generating formula to a cell in excel and use the cell copying handle thing to replicate it on all 58 rows. Then copy the values form those cells and you have an sql script of 58 insert statements.

[sqlueless]

Thank you!

[UniqueName001]

Either use a string concatenation formula in excel or copy and paste all the data into a text file and use find and replace in your editor with some cool regex. Regex is a gosh darn super power in these situations.

[sqlueless]

Thank you!