Welcome to WebmasterWorld Guest from 54.163.49.19

Forum Moderators: brotherhood of lan & mack

Message Too Old, No Replies

.dbf files

     
7:15 pm on Dec 26, 2002 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 15, 2002
posts:971
votes: 0


What can you use to view .dbf files - when I open it up in homesite or the like it's a mess. I need to take this file and insert it into a mysql table...easy enough?
9:40 pm on Dec 26, 2002 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member lorax is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Mar 31, 2002
posts:7575
votes: 0


.dbf files are native dbase files. The only way I know of to get them into MySQL is to either open them up with dbase/Foxpro and export them as ASCII comma delimited or some other format easily read in by MySQL or if you have the dbase module installed in PHP use PHP to open up the files and stuff the data into your MySQL database.
3:22 pm on Dec 29, 2002 (gmt 0)

Junior Member

joined:June 24, 2002
posts:85
votes: 0


the best way to use the dbf files in the dbase 3 plus from ashton tate.
use the following format

use (databasename)
list
< it will list out the records >
browse
< to browse the records >
quit
< what else Huh? >

if you are too smart you might consider importing the file in microsoft excel