How to link excel to access in ADO?

How can I write a spreadsheett driven by VBA for a small office supplying 3 products, the system be used to keep track of the sales the company make.The system can use excel worksheets to display data and should createany graphss onto worksheet, provide some GUI functionality to allow easy controll of the system,... show more How can I write a spreadsheett driven by VBA for a small office supplying 3 products, the system be used to keep track of the sales the company make.The system can use excel worksheets to display data and should createany graphss onto worksheet, provide some GUI functionality to allow easy controll of the system, have controls embedded into a worksheet or user form with controls on it, and also save its records to an access DB andnd the database be updated whenever records are deleted, added or modified. The records that the systems keeps track ocontain informationon such as; salesperson'last name, company name, product name,product cost, quantity bought, total cost, discount, date. The system provide functionality such as; display all data, add a new sales record(calculating total cost automatically, including discount where applicable, delete a sales record, show company data, etc.
2 answers 2