+ Reply to Thread
Results 1 to 2 of 2

Filter huge data

  1. #1
    Forum Contributor
    Join Date
    07-17-2020
    Location
    Uzbek
    MS-Off Ver
    Office 365, V 2212
    Posts
    198

    Filter huge data

    Dear MS Office Experts,

    I have a huge data which is more than 15mln rows & 15columns (A1:O15,000,000) and would like to filter them based on my selection/requirements in column A:O itself… The maximum rows in excel is 1,048,576 only and Excel works very slow with a huge data, so my question is that;

    1). Is here a way to use Access as a filtering tool with 15mln rows & 15columns and does it work smoothly or as slow as Excel?
    2). Is there any other alternative simple program to import 15mln rows of data from excel and use it easily and smoothly?

    Appreciate if somebody could provide me a solution or any similar Access templates which can filter huge data.

    Thanks in advance

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Filter huge data

    As you pointed out, Excel can only handle a max of just over 1 million rows, and with that much data, your file will probably be extremely slow.
    So excel will not be able to hold that much data anyway and would therefor not even be an option to consider
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Deleting Row from Huge data
    By ErgoTeam in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-12-2016, 07:49 AM
  2. Replies: 2
    Last Post: 06-12-2013, 07:41 AM
  3. I need help. Huge data source, I need to clean it up. Find and move data macro.
    By sangreal2007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 02:26 PM
  4. Macro to filter a huge dataset
    By zilem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2011, 01:09 PM
  5. How to go End of Huge Data Range?
    By crwiseman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2006, 01:40 PM
  6. [SOLVED] huge huge excel file... why?
    By Josh in forum Excel General
    Replies: 12
    Last Post: 02-09-2006, 06:00 PM
  7. [SOLVED] How to Auto Filter Even and Odd Numebered IPNums from huge collect
    By banu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2005, 04:05 AM

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