Languages :: PHP :: FoxPro to MySQL? |
|||
By: roe1and  |
Date: 07/01/2008 13:17:40  |
Points: 20 | Status: Answered Quality : Excellent |
| Is there an easy way co convert a FoxPro dbf file into mysql? I have tried exporting the information into a text file or even a excel spreadsheet, but foxpro always seems to screw the data up. is there a way of converting if using a php script? | |||
| By: VGR | Date: 10/01/2008 22:58:42 | |
Type : Answer |
| ok. First AFAIK a dbf file is always a dbf file, be it from dBase 3+, DBase IV, with or without Clipper, from Foxpro or not... SO : 1) eXcel should open it ; then save as CSV ; import in MySql using LOAD DATA INFILE (don't forget the escape, line termination and fields separator & optional enclosure - see doc) 2) PHP ccould manipulate the data, bt I'm afraid only via COM/ODBC so it would be slooooowwwww 3) you could re-use foxpro one last time and try to make it export the data in CSV/TXT format ; then import into mysql as above. it should work. Good lucj and come here with details of "foxpro mangled text data" if you have some. |
|||
| By: roe1and | Date: 18/01/2008 11:40:16 | |
Type : Comment |
| i think i have managed. hey vgr, i have applied for another postion in my department here at work: data solutions editor. i just wanted to say thanks for all your patience and help. you've helped me a great deal and i would not have been to do this without you. you're awesome! | |||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
