A Simple Method to Load Excel Data

  • This was removed by the editor as SPAM

  • If the amount of rows and their width is relatively small (say <= 300 rows and <= 30 columns), and it's a one-time task, I usually just use Excel formulas to generate INSERT INTO statements, then copy/paste those into a script. Of course I also have to worry about special characters like newlines and apostrophes in the data, so it's admittedly not that robust. But easy enough for small jobs.

  • It's neither. It's a C# Script Task. It's like a console app for the most part you can do things like MessageBox.Show(msg). People often add these to allow them to see what's going on while troubleshooting.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply