Database & Excel

[Arkhym]

Hello, I am pre-university Computer student writing a pjoect for a major company. Have finished reading Karl Moore's excellent tutorial on VB, helpful, question:
The companies inventory is in Excel, but I want to use VB/Access to manipulate it. Where and what do I put in the program to do this?

[Clunietp]

You could link to the excel sheet from MS Access and manipulate it as a table (and base your forms or querys off of that)

-or-

you can directly manipulate the excel sheet via ADO. Example: http://www.vb-world.net/forums/showthread.php?threadid=11376