How can I upload the data from an Excel Spreadsheet to my database in DB2?

Thanks! :)

the spreadsheet via a DataTable first? SpreadSheet -> DataTable -> DB2

It is possible to connect an excel through an OleDbConnectionString object and it works like a database and the sheet behaves like a table.

ddanbe has provided two great examples of reading the Excel sheets. And This Link directly from IBM shows you how to parse a DataTable into DB2 it's in C# but easy enough to translate.

Job Done =0)

Edited 2 Years Ago by J.C. SolvoTerra

This question has already been answered. Start a new discussion instead.