+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    El Salvador
    MS-Off Ver
    Ms Office 2010
    Posts
    5

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

    Hello ... I'm pretty new here, and I'm amazed by the VBA geniuses in here! If I could ask for your assistance, it certainly won't go unnoticed.

    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?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,851

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

    Suggest you start with reading the following two links, since it appears that you are looking to build a database but have not yet attempted it and have no specific issues.

    http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf

    http://www.accessmvp.com/strive4peace/

    We are here to help you with specific issues, teach you about specific issues, but not to do your work for you or give you a full lesson on how Access or Excel works. Once you have a db and have specific questions, post back and we will certainly help.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel data base or access data base collection?
    By mcdonalds in forum Excel General
    Replies: 0
    Last Post: 02-17-2014, 08:04 AM
  2. Replies: 1
    Last Post: 08-31-2013, 01:36 PM
  3. Macro to delete files base on excel data.
    By visha_1984 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 08:39 AM
  4. Import data from files with different names to EXCEL D'base.
    By thunderfoot in forum Excel General
    Replies: 2
    Last Post: 06-10-2005, 06:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1