LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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!!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel data from spreadsheet to database Ricki Miles Excel Worksheet Functions 1 March 25th 10 06:47 PM
Make an Access Database out of Excel spreadsheet ahmebah New Users to Excel 0 February 11th 05 02:45 PM
Sumproduct in Excel Spreadsheet to read Access db table Jules Excel Worksheet Functions 1 November 9th 04 02:50 PM
Import of Database VB app into Excel Spreadsheet No Name Excel Programming 0 February 19th 04 06:23 PM
convert Works 3.0 database spreadsheet into excel 97 Brenda[_6_] Excel Programming 0 January 19th 04 03:51 AM


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"