Simple Material Log

Submitted by: 
Visitors have accessed this post 3388 times.

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

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 for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


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.


Hi Experts,

Need project in MS access to import excel file in access multiple table using vba code.

Thanks in advance

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.