Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    New Jersey, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet into Access (2.0)

    I am not sure how to go about this.

    What I would like to do is instead of using an Excel spreadsheet for the die locations, I want to use Access. It would make updating this much easier.

    I'm not sure how to go about doing this. A straight table won't come close. A crosstab query may help me out, but I was having trouble with the value part.

    I attached the spreadsheet.

    ANY ideas are welcome.

    Thanks,
    Mark
    Attached Files Attached Files

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Worksheet into Access (2.0)

    Post deleted by GARYPSWANSON
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Worksheet into Access (2.0)

    If you build the tables like worksheets, then there is no earthly reason to use Access at all, since you can't take advantage of relational design.
    Charlotte

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Worksheet into Access (2.0)

    ... Very good point.
    Regards,

    Gary
    (It's been a while!)

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Worksheet into Access (2.0)

    To utilize the relational design in access, you could do the following:

    1. Create a Table to store the locations, i.e., 1,2,3,4,etc.
    2. Create a Table to store Bins, i.e,. A1, A2, A3
    3. Create a Table to store Dies

    Link the Location table to the Bin table as a one to many relationship. (I.e,. A location can have many bins)
    Link the Bins table to the Dies table based on your requirements. (i.e,. A bid can hold one die or a bin can hold many dies)

    You can then use forms, queries, etc, to enter data, search data, or create the reports you need.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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