How do you edit a DBF file?

[slicksilver]

We have a POS program which exports the price list in DBF file format. The idea behind editiing in the DBF file is to make mass changes. The menu based system in the program allows me to make the changes in the program but it takes too long and is tedious.

The file is about 42kb and is named as xxxx.DBF . Can't find a website to upload the file.

BTW I have no programming background. I'm proficient in Excel.

Thanks in advance!

 

[Ken g6]

I'm guessing those are dBASE files. Looks like OpenOffice can probably open them. Can Excel not?

Of course, that's no guarantee you can get the results back into the DBF file.

 

[Nothinman]

You'll need to poke around in the file yourself and see if you can figure out what it is, the 'file' command on Linux may help if it's a common format. However it may be a custom format used by that POS system.

 

[brandonb]

.DBF is used by Fox Pro. If you can find a copy of that anywhere.

http://en.wikipedia.org/wiki/Visual_FoxPro

 

[Markbnj]

For manual editing this looks like it will work: http://www.dbfview.com/

If you want an API...

http://javadbf.sarovar.org/
http://social.msdn.microsoft.com/Fo...s/thread/c69b0b4b-f801-49a0-bb34-75d9a42b6b07

Note that .NET has a data provider binding for .DBF files, so you should be able to roll your own pretty easily there as well.

Also, have not used any of these tools, so these are not recommendations.

 

[DaveSimmons]

Which version of Office? A Google of "Excel 2007 dbase" found this:

http://www.pcreview.co.uk/forums/thread-3775852.php

- Access 2007 can still read dbf
- There is a dbf add-on for Excel
- Open Office can write dbf

I haven't verified any of that. I did write a DBF data importer for a previous employer back in the 20th century, but the code belongs to them and wouldn't help you.

 

[slicksilver]

Which version of Office? A Google of "Excel 2007 dbase" found this:

http://www.pcreview.co.uk/forums/thread-3775852.php

- Access 2007 can still read dbf
- There is a dbf add-on for Excel
- Open Office can write dbf

I haven't verified any of that. I did write a DBF data importer for a previous employer back in the 20th century, but the code belongs to them and wouldn't help you.

Native excel is not able to cut it.

 

[slicksilver]

For manual editing this looks like it will work: http://www.dbfview.com/

If you want an API...

http://javadbf.sarovar.org/
http://social.msdn.microsoft.com/Fo...s/thread/c69b0b4b-f801-49a0-bb34-75d9a42b6b07

Note that .NET has a data provider binding for .DBF files, so you should be able to roll your own pretty easily there as well.

Also, have not used any of these tools, so these are not recommendations.

dbfview trial version did the trick. I'll be buying the full version soon. Thanks!