• Hi Guest: Welcome to TRIBE, the online home of TRIBE MAGAZINE. If you'd like to post here, or reply to existing posts on TRIBE, you first have to register. Join us!

Need to open a DBF with 400,000 entries.


TRIBE Member
I have a big DBF file (it's text, comma seperated) that has 400,000 entries.
ACT, Word and Excel CANNOT open it. I can view it in notepad.

I've been on google but the software I found don't seem like they support a database this size.

I need to find something that I can view/search/lookup/and export parts of the database.

Any suggestions .

Alex D. from TRIBE on Utility Room


TRIBE Member
What do you need to do to it?

May be easier to cut it up into several smaller files depending on the software and hardware you have available.

You can do this in notepad or textpad if you copy the headers for each file.


TRIBE Member
You can import it into Access pretty easily. Then you can view / search / lookup / export to your heart's content.


TRIBE Member
I ended up breaking it up in notepad and using excel ( I don't have access ).
The file is all the business listings for Ontario(name,address,phone,sic code)
So, it took an hour but now I've reduced the database to what I need (which is just under 3000 listings).

Thanks - I still may try access for future listings.

tribe cannabis accessories silver grinders