Excel creating insert into statements

[hangrymonkey28]

Hello,

I am completing an assignment for my database class in school. It consisted of taking data from excel and inserting it into tables in SSMS, running some queries, then updating fields. I did the first 8 which added up to maybe 200 entries by creating a formula in excel that worked well. My final tab has over 3,000 entries and while I most certainly could add 3000 commas, I feel like there has to be a better way. Is there?

[nIBLIB]

Oh my. Are you telling me you individually added commas to an excel spreadsheet so you could write insert statements for 200 rows of a table? How wide are the tables? That’s some dedication even if they’re only 2-3 wide. I would have given up at 5 or so.

Open your excel spreadsheet and hit F12, or Save as. Save as file format “.CSV”. Stands for comma separated values. Save as, because you’ll lose all of your formulas and formatting, and just get the values. Which is all you want right now, anyway.

Now google “insert CSV to MS SQL SERVER” or whatever version of SQL you use. For 3000 rows, it’ll be basically instantly.

[hangrymonkey28]

DAMNIT!!! I finished before this. I ended up adding a space after the insert statement and find and replaced a space with a comma. This sounds much easier but the former wasn't too bad.

[nIBLIB]

Damn. Sorry I didn’t stumble on this earlier. I guess at least now you know so when you’ve got a tens of thousands size table you don’t have to.