Current location - Training Enrollment Network - Books and materials - I am making a book management system. I want to know how to add external access database and excel file to vb program. Is there a tutorial?
I am making a book management system. I want to know how to add external access database and excel file to vb program. Is there a tutorial?
There are two simple ways to connect VB to ACCESS, ADO and DAO, both of which can refer to class libraries or directly use controls. Personally, I suggest using ADO, class libraries and controls.

VB connects to Excel, and you can directly use Excel controls or Excel class libraries.

Suggestion:

1. Understand VB first and write a few simple programs. If you know VB, then skip the first step.

2. Establish a simplest database.

3. Download a VB connection access routine, ADO is easy to find, have a general look.

4. Download a routine of VB connecting to Excel, and have a general look.

5. Try to modify the routine and connect to your own database, excel.

6. Download the tutorial and learn advanced development. Excel is not needed, ADO has many advanced skills.