Member Avatar for xuexue

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

Thanks! :)

  • 5 Contributors
  • 8 Replies
  • 390 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by J.C. SolvoTerra

Recommended Answers

All 8 Replies

Member Avatar for J.C. SolvoTerra

Could you not parse the spreadsheet via a DataTable first? SpreadSheet -> DataTable -> DB2

Member Avatar for xuexue

Ok, can you tell me how to code that? :)

Member Avatar for Santanu.Das

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.

Member Avatar for ddanbe

You could start reading this article. On the bottom of this webpage you'll find related articles.
Example with DataTable.

Member Avatar for J.C. SolvoTerra

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
Member Avatar for xuexue

Got it already! Thanks so much! :)

Member Avatar for J.C. SolvoTerra

Just out of interest Xuexue. How did you end up doing this?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.