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, 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.
- areseeLv 71 decade agoFavorite Answer
Create a blank database, then in the database window up to File, get external data, link and navigate to the spreadsheet and just follow the prompts. Then any time the spreadsheet is updated, so the database will too.
- Anonymous1 decade ago
Something to do with CSV files, browse google, im not sure if you simply save your excel data as .csv or there is someother way, but know this has something to do with it.
Hope this helps