RE: [PHP-WIN] data format..

hi guys, thnx for the info.. As Leon pointed out, am wondering what would happen to the blobs ?? How do i send/convert them to another db format?? Some of the clients r pretty stubborn and wud want to continue with whatever db they hv.. dbase, excel or whatever.. I personally hv never worked with dbase so dont hv much to say about it. will keep working on this and get bak to u guys if i run across more problems.. meanwhile, if anyone has more ideas/suggestions, pl do mail me.. thnx again, sands -----Original Message----- From: Leon [mailto:ljansen@its.uct.ac.za] Sent: quarta-feira, 4 de Dezembro de 2002 7:02 To: Cam Dunstan Cc: php-windows@lists.php.net Subject: Re: [PHP-WIN] data format.. Hi I have only one major problem with the solution below and that is as follows: MySQL does not follow SQL standards ie: You could have been using data types that would not import to a PgSQL server and there is little to nothing you can do about that!!! Sorry to be the one to tell you this, but I fell in the same trap long ago Cheers Cam Dunstan wrote: > sands, > comma delimited text (or tab delimited) will do for all of them, unless the > dbase app does not have import facility, in which case you could structure > up the data into genereic dbase format yourself, its a fairly simple format, > a header with info about fieldnames, sizes and types, followed by fixed > length records thereafter. Stick with an old format, such as dBase3 or 4 > formats with no index or mdx files associated with same. dbase was the best > thing since sliced bread for years, but it is a little dated these days, > maybe you can charge em more by offering to upgrade them to MySQL / PHP > intranet!! > > Cheers CD > > ----- Original Message ----- > From: "DL Neil" <PHPml@DandE.HomeChoice.co.uk> > To: "Sandeep Murphy" <sandeep.murphy@oni.pt>; <php-windows@lists.php.net> > Sent: Wednesday, December 04, 2002 3:36 AM > Subject: Re: [PHP-WIN] data format.. > > > Hi Sands, > > > > I have a PHP - MySQL site on one hand and various types of clients ... mean > > to say, I hv clients who need the data in the MySQL db supplied to them in > > MS Access, Excel, Dbase formats such that they can integrate the data > > directly into their existing type of database. > > > > for Excel, I can probably create a csv file... any ideas for the other?? > > > > any suggestions as to where I can start & how !!?? > > > > > > =start by searching the archives of this discussion list. > > =dn > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- Leon Jansen van Nieuwenhuizen Personal Computing Services Information & Communication Technology Services University of Cape Town Email: ljansen@its.uct.ac.za __________________________ __________________________ -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php