Extracting data from a zip file.

[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

 

[merlin]

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

Excel can handle .dbf (DBase File) extensions.

 

[Dave Peterson]

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

 

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

 

[merlin]

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

Yes. So be inventive; open it in Access first, or even MS-Dos Editor.

 

[Gord Dibben]

Access will open a *.dbf file.

Gord Dibben Excel MVP

 

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

 

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

 

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

 

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

 

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