Re: Export MySQL --> DBF, CSV, MS Access, or MS Excel?

I simply have to agree with you, b.a.t. I too would love to know the format of the Excel file. Those pesky files! hehe, If you find out, let me know. I haven't tried to find out myself. But i have needed to know. TIA! ~nicole amashta www.aeontrek.com "B.A.T. Svensson" <B.A.T.Svensson@lumc.nl> wrote in message news:27E647E5629ED211BF78009027289C6303C1B6A1@mail1... > "Svensson, B.A.T. (HKG)" <B.A.T.Svensson@lumc.nl> wrote: > > >> >Where should I look for information to dump MySql tables to > >> >other formats so the client can download the data? > >> > > >> >dBase, comma-delimited, Access, and Excel are > >> >formats I find useful. > > [REMARK: BELOW IS WHAT _I_ (BAT Svensson) DID WROTE] > > >> Has MS published the file format of MS Excel files??? > > From: Piotr Pluciennik > > > >You don't need to know formats of these files. > > Just as I can't tell what you need and not need to know, you can tell what I > need an not need to know. ;) > > >Reasonable way is to use ODBC interface or in case of > >Access and Excel - COM model. > > Thanks for you answer, but you did not answer my question, considering > weather MS has published the file format of MS Excel or not. > > If one is happy to treat MS Excel files as lumps of binary data, fine with > me, but I am curious about weather MS actually has published the file format > of MS Excel, mainly because end users that requires me to process data > continues to send these binary junk files, a.k.a. MS Excel files, and it > would be nice to write a parser that could extract the data in some usable > form. > > It would be nice to have a file format in order to write a program to > extract data from those junk files. > > > ODBC will be easier. > > Here me now and belive me later: ODBC it self wont make it easier... > > /Anders