dbf editor
Moderator: General Moderators
dbf editor
Does anybody know of a good dbf file editor. Excel can edit these files, but when I save them, I lose about 3/4 of their data. I really need to be able to edit dbf files easily... ANY help would be GREATLY appreciated!
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Aren't dbf's Foxpro data files? I think Access can open them, I would just suggest you use access on copies and not the actual data files. Also, I think there are a few commercial (inexpensive) dbf editor's out there. I had to look for one a few weeks ago but scrappped the project when the original software developer finally came around and said they would edit their program.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
So it isn't just me
. I was looking around for a dbf editor. There are tons of them out there. Some were selling for as low as $19.
Another possibility.... download the trial of SQLYog and see if you can use the Data Transformation tool to move data from the DBF to a MySQL database locally. I totally don't know if this will work, but it might. I have used it to DTS data from Access to MySQL then from MySQL to SQL Server. (I know Enterprise Manager can DTS from Access to SQL Server, but I was playing with my new software
).
Another possibility.... download the trial of SQLYog and see if you can use the Data Transformation tool to move data from the DBF to a MySQL database locally. I totally don't know if this will work, but it might. I have used it to DTS data from Access to MySQL then from MySQL to SQL Server. (I know Enterprise Manager can DTS from Access to SQL Server, but I was playing with my new software
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
I could be wrong, but I thought they were. Actually, after looking around, I think you are right.
While looking, I ran across an app that has a trial version. It is called DBFManager from Astersoft. Might be worth taking a look at if you only need the functionality for a short while. Of course, this particular software is only $39 so it might be worth it to buy a license if you are going to be doing work like this a lot.
While looking, I ran across an app that has a trial version. It is called DBFManager from Astersoft. Might be worth taking a look at if you only need the functionality for a short while. Of course, this particular software is only $39 so it might be worth it to buy a license if you are going to be doing work like this a lot.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Also, when I open a dbf file with that editor it prompts for a .dbt file, and there just happens to be another file with the same name, but that extension in the same directory, but when I export out of the program, it creates another .dbt file... and then it corrupts my database... I am about to give up on the ability to edit these files.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
dbftools (freeware)
http://www.freewarefiles.com/program_8_88_2027.html
There's also a nifty Perl module called Xbase for manipulating DBF files, if you're into that kind of thing:
http://www.fi.muni.cz/~adelton/perl/man3/XBase.html
http://www.freewarefiles.com/program_8_88_2027.html
There's also a nifty Perl module called Xbase for manipulating DBF files, if you're into that kind of thing:
http://www.fi.muni.cz/~adelton/perl/man3/XBase.html