how to read excel spreadsheet into database (DB2)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello

I want to read the contents of a spreadsheet and then insert them into a DB2 database. The DB2 stuff I can do, but I don't see a clear example of how to create a recordset from the rows of a spreadsheet. I have a fixed format spreadsheet, so I know that I want the first, sixth, ninth and eleventh columns of the row. I also know that the first is text, the rest are integer.

Any code examples or snippets out there? I would really appreciate any assistance. And, could you reply both here and to my email? it's mairhtin at techsolutionsgroupllc dot com

THANKS!!!!
 
You might look at Mr. Erlandsen's site:
http://www.erlandsendata.no/english/vba/adodao/index.php

He shows Excel to Access, but it should be easily adaptable.

--
Regards,
Tom Ogilvy


mairhtin o'feannag said:
hello,

I want to read the contents of a spreadsheet and then insert them into a
Click to expand...
DB2 database. The DB2 stuff I can do, but I don't see a clear example of
how to create a recordset from the rows of a spreadsheet. I have a fixed
format spreadsheet, so I know that I want the first, sixth, ninth and
eleventh columns of the row. I also know that the first is text, the rest
are integer.
Any code examples or snippets out there? I would really appreciate any
Click to expand...
assistance. And, could you reply both here and to my email? it's mairhtin
at techsolutionsgroupllc dot com.
 
Back
Top