Results 1 to 3 of 3

Thread: Open Excel Spreadsheet as database?

  1. Jul 19th, 2000, 08:17 AM #1
    DZ
    DZ is offline

    Thread Starter
    New Member
    Join Date
    Jul 2000
    Location
    Cincinnati, Ohio
    Posts
    1

    I have some data that i need to look up in tables and translate that data onto an excel spreadsheet. The data that has to be looked up is also on an excel spreadsheet. I've been working on a Visual basic program to do this, but can't find a way to open an Excel spreadsheet (in code if possible) and pull info from it as if it were a database. Any suggestions on how to do this would be much appreciated!
    Reply With Quote Reply With Quote
  2. Jul 19th, 2000, 10:53 AM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    here is some code to open an excel spreadsheet using ADO:

    http://forums.vb-world.net/showthrea...threadid=23151
    Reply With Quote Reply With Quote
  3. Jul 20th, 2000, 06:20 AM #3
    sbain
    sbain is offline
    New Member
    Join Date
    Jun 2000
    Location
    Bolton,England
    Posts
    5

    Thumbs up

    Have a look at my posting username as sbain (just posted today).
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width