J
Joshua Campbell
Several years ago, I wrote a program that parses out a flat file, stores the
values in various DataTables, then places the values from the DataTables
into an Excel spreadsheet. That has worked wonderfully for years. Now, my
boss has come to me to get this program to do one more thing. Basically,
now I also need to upload this data to a SQL server. Is there an easy and
efficient way to do this, or am I going to have to build one heck of an
elaborate INSERT command? If it helps at all, the field names in both the
SBL DB and the DataTable can be the same (I haven't made the SQL DB yet.)
Thanks
Joshua
values in various DataTables, then places the values from the DataTables
into an Excel spreadsheet. That has worked wonderfully for years. Now, my
boss has come to me to get this program to do one more thing. Basically,
now I also need to upload this data to a SQL server. Is there an easy and
efficient way to do this, or am I going to have to build one heck of an
elaborate INSERT command? If it helps at all, the field names in both the
SBL DB and the DataTable can be the same (I haven't made the SQL DB yet.)
Thanks
Joshua