From DataTable to SQL database

[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

[Mike McIntyre]

You may want to consider handling this form the database side e.g. use SQL
server's ability to import Excel worksheets.
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com
"Joshua Campbell" <Jo*************@nospam.nospam> wrote in message
news:eB**************@TK2MSFTNGP11.phx.gbl...

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

[Joshua Campbell]

Oh well. I'll just create the INSERT statement then. Thanks.
"Mike McIntyre" <mi****@dotnetshowandtell.com> wrote in message
news:uI**************@TK2MSFTNGP12.phx.gbl...

You may want to consider handling this form the database side e.g. use SQL
server's ability to import Excel worksheets.
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com
"Joshua Campbell" <Jo*************@nospam.nospam> wrote in message
news:eB**************@TK2MSFTNGP11.phx.gbl...

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