A Simple Method to Load Excel Data

Question

A Simple Method to Load Excel Data

January 16, 2024 at 3:21 pm

This was removed by the editor as SPAM

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

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

john.brooking SSC-Addicted Points: 417 More actions · Answer 1

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.

edmil SSC Journeyman Points: 92 More actions · Answer 2

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.