Results 1 to 3 of 3

Thread: Excel Newbie Question: .dbf file import help - 1 mil+ rows

  1. #1

    Unhappy Excel Newbie Question: .dbf file import help - 1 mil+ rows



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi:

    I am trying to import a .dbf file into excel. I saved it to my desktop and it says it's 372 MB - compressed size 56 KB. So, I imported, but there are more than 1 million rows, so I can only see part of the data.

    Can someone tell me how to import 1 million records at a time, so I can obtain all the data in the file.

    I tried opening in Access - wouldn't work. The only way I know to open a .dbf file is to right click and it automatically opens in excel. This is normally fine, but not with such a large file.

    Thank you so much for any help you experts can provide.

    Lisa

  2. #2
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    113
    Articles
    0
    Hi Lisa

    If you have Power Query available to you, then you should be able to load it to the Data model for use with Power Pivot.
    Within the cache there, you can have 100 million rows.
    You could then write the data back out to separate worksheets of less than 1 m rows each if needed.
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

  3. #3
    Quote Originally Posted by Roger Govier View Post
    Hi Lisa

    If you have Power Query available to you, then you should be able to load it to the Data model for use with Power Pivot.
    Within the cache there, you can have 100 million rows.
    You could then write the data back out to separate worksheets of less than 1 m rows each if needed.
    Hi Roger:

    I mean really newbie...I don't do any programming or anything like that. I just sort, copy and paste. Easy stuff. I was hoping there was a way for someone like me to do it.

    Thank you so much for taking the time to respond.

Tags for this Thread

Posting Permissions

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