Results 1 to 13 of 13

Large Database and Needing to Pull All Row/Column Data for Selected Addresses

  1. #1
    pick44 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    8

    Large Database and Needing to Pull All Row/Column Data for Selected Addresses

    Attached is sample of database I am working on. Need to only pull the row and column information for selected address ranges.

    As example the addresses that I will input need to pull the data from the database and put in new sheet.
    5000-7000 AIRPORT
    50-500 ALDINE BENDER
    3550-7687 BEECHNUT

    First file "excel sample" is the sample file of data information
    Second file" Database pull" is the results I need


    Thank you

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,412
    The two sets of records in the files are the same. There is no worksheet provided so the Excel link is useless.

    There is certainly more than one way to accomplish what you want. One is to have a Yes/No field in table and either manually or with code set value of the field and apply filter.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    pick44 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    8
    The first file has a sample of the large database and the results of what I am trying to do. There are two files in the first.
    In the second file is the results. Sorry I posted twice on the results. I am just getting started on this site and Access.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,412
    The first attachment is just an Access db with a table that has 4 records and a link to an Excel file which you do not provide. The second attachment is another Access db with a table that has the same 4 records and no Excel link.

    My previous comments still apply.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    pick44 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    8
    Okay, I have added the excel file

  6. #6
    pick44 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    8
    file attached

  7. #7
    pick44 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    8
    wrong file. sorry

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,412
    That's a bigger file than I want to download and not sure it would be helpful anyway. I described one method but since your source data is a linked worksheet it is not applicable. Are worksheet columns same as fields in table? Can manually set up query to filter by desired range(s) and run INSERT SELECT action. Automating to allow users to select multiple ranges and dynamically building SQL action statement could be quite complicated. I am not interested in building this for you.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    pick44 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    8
    The attached file hasw 28 rows and a few columns. Did you say it is linked? Please explain. Thanks

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,412
    8.8MB has to be more than just 28 rows and a few columns. You initially provided an Access file with a link set to an Excel worksheet. Is this your actual database structure? Why is Excel involved?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #11
    pick44 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    8
    All of the databases are in Excel Binary. I tried to upload a 28 row sample but it said, not in right format. I tried serveral times, but it said I have to zip the file. So I did. I did not know it had all my records?

  12. #12
    pick44 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    8
    How can I delete this large file so I may continue

  13. #13
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,412
    Uploaded files cannot be deleted from the forum, only from the post, which you seem to have done. You may continue.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 09-28-2017, 11:47 PM
  2. Replies: 9
    Last Post: 06-15-2017, 03:00 PM
  3. Replies: 1
    Last Post: 02-02-2015, 07:58 PM
  4. Replies: 2
    Last Post: 10-29-2013, 04:38 PM
  5. Replies: 10
    Last Post: 11-04-2012, 07:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums