Hello Experts,
I need help with a feature I need implemented to an Access 2013 application.
I am developing a scheduling app. The staff members email me their availability on a spreadsheet.
I then save those spreadsheet to a specific folder in my C drive (C:\Schedules\).
I have a table in Access 2013 where I save the data in the spreadsheets into. This is tedious work.
I want to create a form in Access 2013 with just 1 button, that will read all the files in the C:\Schedules directory.
And import the information into my schedules table.
Image of what my C:\Schedules directory
Here is a sample of the information that the spreadsheets contain:
USER ID DATE_AVAILABLE EMAIL PHONE
100001 11/1/2014 me@test.com 111-112-2233
100001 11/2/2014 me@test.com 111-112-2233
100001 11/9/2014 me@test.com 111-112-2233
100001 11/12/2014 me@test.com 111-112-2233
100001 11/13/2014 me@test.com 111-112-2233
100001 11/14/2014 me@test.com 111-112-2233
My tblSchedules table in Access has the same fields:
USER ID DATE_AVAILABLE EMAIL PHONE
How can I do this? Thank you in advance for all of your help.
mrotor
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.