Coincidentally, I also need a way to read a table from MySQL and write
it out to an .MDB file on-the-fly (from within a PHP script).
The CSV export idea isn't an option in this case.
Has anyone found a way to create an MDB file (with a single table) from
PHP?
...Rene
On 28-Mar-05, at 7:18 PM,
I don't think it's a case of 'finding a way'. I think its a case of
writing some code.
Some pseudo code to get you started:
connect_to_mysql();
$ms_Access_handler = use_com_ole_or_odbc_to_open_an_access_db();
while( $row = get_row_from_mysql() ){
$ms_Access_handler-insert_row($row);
}
MDB suggests Access, so why not simply create a CSV, or some other
generic format file from your MySQL, and import it into access, using
COM/OLE, and save it as an MDB file.
On Mon, 28 Mar 2005 22:14:07 +0100, Shaun [EMAIL PROTECTED] wrote:
Thanks for your reply,
but this only works on
3 matches
Mail list logo
