5
Contributors
8
Replies
42
Views
2 Years
Discussion Span
Last Post by J.C. SolvoTerra
Featured Replies
  • 1
    ddanbe 2,525   2 Years Ago

    You could start reading [this article](http://vb.net-informations.com/excel-2007/vb.net_excel_2007_open_file.htm). On the bottom of this webpage you'll find related articles. [Example](http://vb.net-informations.com/excel-2007/vb.net_excel_oledb.htm) with DataTable. Read More

0

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.

0

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 by J.C. SolvoTerra

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.