Excel to Access database v.v.

  • [xpost][/xpost]

    Hello everyone. It's nice to be back here. Obviously, I need a big help from this forum, again.


    I am to develop a project that would allow may co-team mates to request for Vacations Leaves via Excel (using a Data Entry form). These request will go directly to a database in Access. Why Access? I thought storing a large amount of "request" in Excel would only increase the file size and make it harder for the codes to execute. If I am wrong here, please educate me a better way of resolving that issue.


    With that being said, the file will be shared AND/OR the users can download the file and save a copy of it on their own desktop. Now, since the requests are in a Access database, again please correct me on this part if I have a misconception, the file, even though it has multiple copies outside and shared to different users, it would update real time on the users end. Am I wrong here? Let me know.


    Another dilemma I have is where to save the database that would allow the Excel files to update real-time. I was thinking of shared drive or folder. Is that a possibility? How about One Drive? Can it do the work?


    The project right now is in a planning phase. I want to sort out this questions first before I start doing it and I think this is the best place to ask for guidance.

    If it helps, I am using an Office 365.

  • Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. We are here to help so help us help you!


    Read this to understand why we ask you to do this


    Crossposting

  • Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. We are here to help so help us help you!


    Read this to understand why we ask you to do this


    Crossposting

    Thank you for the reminder, I didn't realize it's a thing. Will follow this moving forward.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!