RE: [PHP-DB] php- odbc- access

2002-12-11 Thread Snijders, Mark
don't think it's possible @ once...

what  I suggest... those people have to make a comma delimited export file,
then you make an upload page, where people can upload this file. and you
make a script so it will be imported

get the point?

kind regards



 

___ 

Mark Snijders, Developer 
Atos Origin 
Groenewoudeseweg 1, Room VN-515 
5621 BA  Eindhoven, The Netherlands 
*   : [EMAIL PROTECTED] 
*:+31 (0)40 - 2785992 (tel) 
* : +31 (0)40 - 2788729 (fax) 

The information in this mail is intended only for use of the individual or
entity to which it is addressed and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
Access to this mail by anyone else than the addressee is unauthorized. If
you are not the intended recipient, any disclosure, copying, distribution or
any action taken omitted to be taken in reliance of it, is prohibited and
may be unlawful.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP-DB] php- odbc- access

2002-12-11 Thread SELPH,JASON (HP-Richardson,ex1)
There are programs that can import access db files into mysql, but none that
I know of that are automated.  If you have access to the access app they are
running, you can install an odbc connection from their machines to your
mysql database and modify your access app to connect to mysql and copy the
records over.

You can also have them export their data to a CSV file, upload that file and
mysql can import it.  Other than that I am not sure what you can do.

Cheers
Jason

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 7:41 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php- odbc- access


Many of the people who will be using my php site, will also be using an app
that runs an access db.  I would like to create a page on my webpage that
allows the users to click a button, and data is moved from their access db
on their machines, to my mysql db.  Is this possible?  I will know where the
access db file lives.   Can php make an odbc connection and do the transfer?
Can I upload the db file to my webserver and then transfer?

Thanks,
Eddie


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php