A simple description of what I am trying to do, I have a small company and I use excel to create order forms from a template I made. Then I save each workbook under a folder in my computer as "Customers"
I am trying to see if I can get Access to create a productions list from this folder using "Customer Name" field in each workbook...and when i save a new excel file in that folder, it automatically updates the Access production list. I am not sure that this is even possible. I do not know much about access so I used excel to run my company thus far.
basically, can Access take a specific cell from several Excel files and put in in a database?
I am trying to see if I can get Access to create a productions list from this folder using "Customer Name" field in each workbook...and when i save a new excel file in that folder, it automatically updates the Access production list. I am not sure that this is even possible. I do not know much about access so I used excel to run my company thus far.
basically, can Access take a specific cell from several Excel files and put in in a database?