• 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.

Lofty

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 .

Lofty
 

ian

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.
 

Stan

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

Lofty

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.

Lofty
 
tribe cannabis accessories silver grinders
Top