Need project in MS access using VBA code
Hi Experts,
Need project in MS access to import excel file in access multiple table using vba code.
Thanks in advance
Simple Material Log
Submitted by proudpinoy357 on Friday, December 6, 2013 - 07:18.
Language
This system is quite different. Simple but essential for the beginners. Its quite different from usual access used. Mostly, we input data to the tables using forms. This system you will input data by microsoft excel and view reports to microsoft access. Any changes you made to excel it will reflect in access.
Note: Copy the microsoft excel file to Drive D then create shortcut to the desktop as your interface. Access file you put anywhere as you wish. Yet, I recommend to put into trusted location
Bonus:
You can create and delete table using button.
Good Luck...
Best regards to all sourcecodester....
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Comments
Add new comment
- Add new comment
- 187 views
