wolfmah
January 25th, 2003, 12:03 AM
Hi there, I'm in the search of a little something that could convert MySQL queries results into Access tables. I have search the web for quite some time and the only applications I could find are static ones that can only convert an entire database and they are not applicable for online use.
My problem is that I want the user of a web site I make to be able to query a database and this query would be handle through a php script to make a good looking output. But, my user want to be able to download the query result (not the entire database) into a form that is easy for him to handle. For now, I use a .txt file that he need to convert in Excel, than take the Excel file into Access. That is too long and complex, I want him to be able to download an Access file directly through a simple link.
The problem is that I freaking don't know how to make this, I don't know how the .mdb file are organised. Is there a way I can make this possible or is there anyone that already made this possible that I don't know about? The programming language is not a restriction for me, it can be Java, PHP, Perl, C++, VB .Net I don't care, I can handle them all. As long as you can provide me with some info about how I can make a convertion online with a query result of a database, I will be happy :)
My problem is that I want the user of a web site I make to be able to query a database and this query would be handle through a php script to make a good looking output. But, my user want to be able to download the query result (not the entire database) into a form that is easy for him to handle. For now, I use a .txt file that he need to convert in Excel, than take the Excel file into Access. That is too long and complex, I want him to be able to download an Access file directly through a simple link.
The problem is that I freaking don't know how to make this, I don't know how the .mdb file are organised. Is there a way I can make this possible or is there anyone that already made this possible that I don't know about? The programming language is not a restriction for me, it can be Java, PHP, Perl, C++, VB .Net I don't care, I can handle them all. As long as you can provide me with some info about how I can make a convertion online with a query result of a database, I will be happy :)