Setting up Look up Data Base with Scheduling Ability (data in several excel files)

[BleuDrache]

Hello ... I'm pretty new here, and I do hope that I'm doing things right posting like this:

Here's what I want to do with an Access Data Base:

Thanks to some help kindly provided, I was able to create excel files out of a "mother file", which generates files in a certain folder with an established format, like this: "M-12345678 1234", now, what I would like to do with Access is to create a data base which can screen those files, find some dates that are contained in a sheet within those files and from those, to be able to generate a schedule according to the dates in some of those cells (date cells), also, according to those files, to look up or screen the files that match certain criteria, such as date, code or some other data that all those files share in certain cells.



May I respectuflly ask some help, ladies and gents?

[ranman256]

If you are talking about importing data from the excel file, I would use this method:
1. link 1 of the excel files to access as a generic table: xlImportFile
2. build an import query: qaImportXL , that will import the data from xlImportFile to an internal table.
3. macro to run the import query.

To import data:
1. relink the xlImportFile table to a new file
2. run the import macro.

Now at this point you would do things to the import data to build your schedule, but I dont know the nature of the data.