Extracting data from a zip file.

  • Thread starter Thread starter Rodney
  • Start date Start date
R

Rodney

I have a *.dbf file, with what I assume to be about
140,000 records.
How would I open this to extract all records?
Thanks
 
Rodney said:
I have a *.dbf file, with what I assume to be about
140,000 records.
How would I open this to extract all records?
Thanks
Click to expand...

Excel can handle .dbf (DBase File) extensions.
 
But 140,000 records seems like it will cause a problem since there's only 65536
rows in a worksheet.
 
Can you open the .dbf file in another program (maybe a different database
program--or even dBase)?

Then save it in parts less than 64k each--either as .dbf or even .csv?

(I don't know if that's even possible.)
 
Dave Peterson said:
But 140,000 records seems like it will cause a problem since there's only 65536
rows in a worksheet.
Click to expand...
Yes. So be inventive; open it in Access first, or even MS-Dos Editor.
 
When I saved some test data as a .dbf file (dBase IV), it didn't look too nice
when I opened it in my favorite text editor. (I don't have Access installed to
use.)
 
Then you can save portions of the database?

Open the file in access, keep the top 40k, delete the rest and save that as
..CSV???

Repeat that as you go down the data and then open each of those files separately
in excel???
 
Thanks to Merlin, Gordon and Dave,
I'll try and locate someone with Access to
open it for me.
Appreciate the replies.

Rod



| I have a *.dbf file, with what I assume to be about
| 140,000 records.
| How would I open this to extract all records?
| Thanks
|
|
|
 
http://www.dbfview.com/

Thanks to the guys in the MSWorks Newsgroup.
140,000 reords now loaded into Excel.


| I have a *.dbf file, with what I assume to be about
| 140,000 records.
| How would I open this to extract all records?
| Thanks
|
|
|
 
Thanks for posting back.

Now google knows, too.
http://www.dbfview.com/

Thanks to the guys in the MSWorks Newsgroup.
140,000 reords now loaded into Excel.

| I have a *.dbf file, with what I assume to be about
| 140,000 records.
| How would I open this to extract all records?
| Thanks
|
|
|
Click to expand...
 
Back
Top