Due date database pulling from multiple spreadsheets

[dcavender]

Hello everyone,



I'm new to this online community and not sure if I'm posting in the correct location. I and trying to set up an access database that pulls information from several different excel files. Specifically I have excel files that track different action items based on due dates and I'd like to set up an access program that monitors the upcomming action items. I have no idea how to go about this or if its even possible. Any suggestions or a general point me in the right direction would be greatly appreciated.

Thank you so much.

[JoeM]

You can link Excel data to Access.
See: http://office.microsoft.com/en-us/ac...001095095.aspx

[dcavender]

Hello Joe, I may be misunderstanding the linked data, but I dont think that is what I need. I need the Access sheet to be selective about the data it links. So for example I have 4 spreadsheets that have rows of data all with a future date in the second column. I need the access to compile the the rows of information from the multiple spreadsheets of only the dates that are say.. 3 months out. Is that the same as just linking?

[JoeM]

I may be misunderstanding the linked data, but I dont think that is what I need.

Link to ALL the data. Then use Queries to select just what you want to see (that is one of the main functions of queries - to filter/select just the data you want to see).