Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to read excel spreadsheet into database (DB2)
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!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to read excel spreadsheet into database (DB2)
You might look at Mr. Erlandsen's site:
http://www.erlandsendata.no/english/...odao/index.php He shows Excel to Access, but it should be easily adaptable. -- Regards, Tom Ogilvy "mairhtin o'feannag" <mairhtin at techsolutionsgroupllc dot com wrote in message ... 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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel data from spreadsheet to database | Excel Worksheet Functions | |||
Make an Access Database out of Excel spreadsheet | New Users to Excel | |||
Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
Import of Database VB app into Excel Spreadsheet | Excel Programming | |||
convert Works 3.0 database spreadsheet into excel 97 | Excel Programming |