+ Reply to Thread
Results 1 to 4 of 4

.dbf file import help - 1 mil+ rows

  1. #1
    Registered User
    Join Date
    01-24-2015
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    2

    Question .dbf file import help - 1 mil+ rows

    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
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,054

    Re: .dbf file import help - 1 mil+ rows

    Hi, welcome to the forum

    So, I imported, but there are more than 1 million rows, so I can only see part of the data.
    I have not imported anything that large before, but excel has 1 048 576 rows. What are you seeing, and what is missing?
    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

  3. #3
    Registered User
    Join Date
    01-24-2015
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    2

    Re: .dbf file import help - 1 mil+ rows

    The excel sheet is completely full which tells me that there is much more data available, but it wouldn't fit on the sheet.

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,262

    Re: .dbf file import help - 1 mil+ rows

    Maybe
    Chip Pearsons ImportBigTextFile macro
    http://www.cpearson.com/excel/importbigfiles.aspx

    You would need to re-save the file as txt.

    On the other hand - maybe you should be using access for this much data.

+ 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. import text file with 2 rows per record into 1 row
    By kblinkhorn in forum Excel General
    Replies: 2
    Last Post: 01-10-2013, 11:42 AM
  2. Delete i Rows in Text File Import
    By cswale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2011, 06:50 PM
  3. how do I import a CSV file with more than 65536 rows
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-14-2006, 10:50 AM
  4. [SOLVED] Import txt file with multiple rows for each record
    By VanessaNY in forum Excel General
    Replies: 4
    Last Post: 09-15-2005, 03:05 PM
  5. Import only certain rows of a huge text file
    By AriBari in forum Excel General
    Replies: 4
    Last Post: 07-11-2005, 01:54 PM

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