I'm very new to Access so I wasn't sure which forum category to post this in--forgive me if this isn't the right spot! I have created a form that gets emailed out to and filled out by thousands of potential clients, and was wondering if there's a way to automatically upload the info that's in the form to a database and/or into excel? We are currently doing this on a manual basis and it is is becoming unsustainable given how many forms we receive every day, and makes us susceptible to making mistakes.
Here are some examples of what the form categories are:
- Name
- Telephone Number
- Office Branch Number
- Employee Number
- Date
- Billing Information (card type, card #, etc.)
Any insight would be much appreciated. Thank you!