Data upload to DB2 Tables

Results 1 to 2 of 2

Thread: Data upload to DB2 Tables

  1. #1
    Join Date
    Dec 1969

    Default Data upload to DB2 Tables

    Hi, I am developing a .NET application and the users want to be able to upload about 1000 rows of data to DB2 via an excel spreadsheet. Is there a simple way to do this? The data would be inserted into many different tables.

  2. #2
    Join Date
    Dec 1969

    Default RE: Data upload to DB2 Tables

    Does it have to be an Excel document? You can use one of the generic data access classes (Odbc or OleDb) to read an Excel document, then insert it into your DB2 tables as you like.<BR><BR>ALL of my experiences with trying to programmatically maniupulate Word or Excel have ended in tragedy. If you can get your uploads in a plain-text format you will be much happier. If the users want to use Excel, have them save it as a CSV file, it&#039;s just plain text that way.<BR><BR>Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts