Re: [PHP] Re: Create MDB File
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, Rory Browne wrote: 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 Windows. I need a program that will create an MDB file on the fly from a query on the MySQL database... Johannes Findeisen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sorry, i forgot that link: http://www.convert-in.com/sql2acc.htm On Monday 28 March 2005 22:46, Johannes Findeisen wrote: Hello, i had the same problem some years ago. At this time i have set up all tables in Access and wrote a script which reads from MySQL and inserts into the MDB file via the ODBC connector. This works but is much work when your database is very big. 2 Years ago i had the same problem but it must go as fast as possible so i decided to buy a converteer since i didn't find anything free. They are working very good. I don't know where i have buyed them but i think there is only one company which delivers this software. Regards Johannes On Monday 28 March 2005 22:08, Shaun wrote: Hi, Does anyone know if its possible to create an MDB file from a Mysql database using a PHP script, I have only managed to find Access to Mysql conversion programs so far... Thanks for your help -- # Johannes Findeisen -- # Johannes Findeisen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Create MDB File
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);
}
$ms_Access_handler-save_db(filename.mdb);
Just a thought.
On Thu, 31 Mar 2005 12:36:51 -0700, René Fournier [EMAIL PROTECTED] wrote:
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, Rory Browne wrote:
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 Windows. I need a program that will create an
MDB
file on the fly from a query on the MySQL database...
Johannes Findeisen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Sorry,
i forgot that link:
http://www.convert-in.com/sql2acc.htm
On Monday 28 March 2005 22:46, Johannes Findeisen wrote:
Hello,
i had the same problem some years ago. At this time i have set up
all
tables in Access and wrote a script which reads from MySQL and
inserts
into
the MDB file via the ODBC connector. This works but is much work
when
your
database is very big.
2 Years ago i had the same problem but it must go as fast as
possible so
i
decided to buy a converteer since i didn't find anything free. They
are
working very good. I don't know where i have buyed them but i think
there
is only one company which delivers this software.
Regards
Johannes
On Monday 28 March 2005 22:08, Shaun wrote:
Hi,
Does anyone know if its possible to create an MDB file from a Mysql
database using a PHP script, I have only managed to find Access to
Mysql
conversion programs so far...
Thanks for your help
--
# Johannes Findeisen
--
# Johannes Findeisen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Create MDB File
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 Windows. I need a program that will create an MDB file on the fly from a query on the MySQL database... Johannes Findeisen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sorry, i forgot that link: http://www.convert-in.com/sql2acc.htm On Monday 28 March 2005 22:46, Johannes Findeisen wrote: Hello, i had the same problem some years ago. At this time i have set up all tables in Access and wrote a script which reads from MySQL and inserts into the MDB file via the ODBC connector. This works but is much work when your database is very big. 2 Years ago i had the same problem but it must go as fast as possible so i decided to buy a converteer since i didn't find anything free. They are working very good. I don't know where i have buyed them but i think there is only one company which delivers this software. Regards Johannes On Monday 28 March 2005 22:08, Shaun wrote: Hi, Does anyone know if its possible to create an MDB file from a Mysql database using a PHP script, I have only managed to find Access to Mysql conversion programs so far... Thanks for your help -- # Johannes Findeisen -- # Johannes Findeisen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: Create PDF FIle
[snip] I use the pdf class from http://www.potentialtech.com Todd [/snip] There are built-in PDF functions http://us4.php.net/pdf and others use the class from http://www.fpdf.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Create PDF FIle
I use the pdf class from http://www.potentialtech.com Todd Mike Mapsnac wrote: Hello I want to create PDF file from PHP output. So instead of sending output to the browser, I need to insert PHP output into PDF FILE. How that's can be done? Looking for some short example or some documentation. Thanks _ Let the new MSN Premium Internet Software make the most of your high-speed experience. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: create a file
I found it. Thomas Franz [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED]; good morning, i want to create a new file and save it in the current dir. I look in the manual but only i found how to create a dir. Thanks for help. Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: create a file
Start here... http://www.php.net/manual/en/function.fwrite.php From: [EMAIL PROTECTED] (Thomas Franz) Newsgroups: php.general Date: Fri, 1 Mar 2002 08:55:25 +0100 To: [EMAIL PROTECTED] Subject: create a file good morning, i want to create a new file and save it in the current dir. I look in the manual but only i found how to create a dir. Thanks for help. Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
