Extracting data from a zip file.

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
 
M

merlin

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

Dave Peterson

But 140,000 records seems like it will cause a problem since there's only 65536
rows in a worksheet.
 
D

Dave Peterson

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.)
 
M

merlin

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

Dave Peterson

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.)
 
D

Dave Peterson

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???
 
R

Rodney

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
|
|
|
 
R

Rodney

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
|
|
|
 
D

Dave Peterson

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