I am tryng to create an access application that browses a folder for excel files with a certian naming convention and imports the first worksheet into an access tables. I am a sql server developer but have very little experience programming in Access. I would imagine this needs to be built with VBA.
Each valid excel sheet represents a buisness unit. The data in each excel spreadsheet is of the same format. There are 12 Business units altogether thus 12 files should be in the driectroy at a given time.
As the files are imported there should be some data validation to ensure that the data is correct. If the data is incorrect it will not be loaded into the database.
Files that are processed should be moved to a different folder. Failed files should remain in the original directory.
I would like to have a way of processing all files at once or an individual file. Therefore I would need some brwosing functionality.
Finally I would like to have some log info which will show what was processed and what was not processed. Maybe some sort of import report.
Any information or ideas would be very much appreciated.
Each valid excel sheet represents a buisness unit. The data in each excel spreadsheet is of the same format. There are 12 Business units altogether thus 12 files should be in the driectroy at a given time.
As the files are imported there should be some data validation to ensure that the data is correct. If the data is incorrect it will not be loaded into the database.
Files that are processed should be moved to a different folder. Failed files should remain in the original directory.
I would like to have a way of processing all files at once or an individual file. Therefore I would need some brwosing functionality.
Finally I would like to have some log info which will show what was processed and what was not processed. Maybe some sort of import report.
Any information or ideas would be very much appreciated.
