killerflappy
Registered User.
- Local time
- Today, 10:15
- Joined
- Aug 23, 2017
- Messages
- 50
Hi Guys,
I have an Access database with order information. Per client I have an Excel file with the orders. I have an import button for the diffrent clients with an automated process for extracting the data to combine the orders.
One client is an expection. The deliver a lot of seperated files. These files are flaced in a (import)folder. We combine the files and then import them. Some files are for the next day. We can see this because in a column is the date for the next day.
I want to automate the import process of the Excel files. The end users clicks on a buttom and import the files that are in the importfolder.
I understand how to loop to the files.
How can I check if the file has the date of today (or earlier) in a column?
How can I move the imported files to a subfolder?
I have an Access database with order information. Per client I have an Excel file with the orders. I have an import button for the diffrent clients with an automated process for extracting the data to combine the orders.
One client is an expection. The deliver a lot of seperated files. These files are flaced in a (import)folder. We combine the files and then import them. Some files are for the next day. We can see this because in a column is the date for the next day.
I want to automate the import process of the Excel files. The end users clicks on a buttom and import the files that are in the importfolder.
I understand how to loop to the files.
How can I check if the file has the date of today (or earlier) in a column?
How can I move the imported files to a subfolder?
Last edited: